Macro Help - Jumping Sheets

Hi All

I have a workbook which contains 400 sheets. What I need
to do is to insert a "cover" sheet and then create a macro
to pick up the same four cells from each worksheet (B2,
G9, B14 and B9) and copy and paste the values into the
Cover Sheet going progressively down a column for each
different sheet.

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

any help is greatly appreciated.

cheers
nick

Hi Nick..........,
This is the third time you posted the same question here in three days.
Stick to your original thread, if there is something lacking in the
replies then specify in the original thread what is wrong, or what you
don't understand. To continually post the same question is a waste
of everyone's time.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Nick" wrote in message ...
Hi All

I have a workbook which contains 400 sheets. What I need
to do is to insert a "cover" sheet and then create a macro
to pick up the same four cells from each worksheet (B2,
G9, B14 and B9) and copy and paste the values into the
Cover Sheet going progressively down a column for each
different sheet.

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

any help is greatly appreciated.

cheers
nick