Hi All

I have a workbook which contains 200 sheets. What I need
to do is to insert a "cover" sheet and then create a macro
pick up 5 cells from each worksheet (the cells don't
alter) and copy and paste the values into the Cover Sheet
going progressively down a column, with a different column
for each cell.

so i need the macro to go to Sheet1 get the cells paste
into correct columns and then go to Sheet2 and repeat the
process, until there are no more sheets left.

Eg. i need b3, b4, c26, e26, h26 from each worksheet in
the whole workbook to be summarised so column A on the
Cover Sheet has

B3 Sheet1
B3 Sheet2
B4 Sheet3
etc...

If anyone can help it would be a massive time saver!

Cheers
Nick