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
to pick up the same five cells from each worksheet (b3,
b4, c26, e26, h26) and copy and paste the values into the
Cover Sheet going progressively down a column for each
cell.

so i need the macro to go to Sheet1 get the value from B3
and paste it on the cover sheet in A2, then get the value
B4 and pasit on the cover sheet in B2 etc... then go to
Sheet2 get the value from B3 and paste it on the cover
sheet in A3, then get the value B4 and pasit on the cover
sheet in B3 etc...

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

Cheers
Nick