Macro required - copy and paste into new workbook.

Hi

I have a workbook with almost 40 worksheets however I want to create a new workbook based on information that in on 17 of the worksheets (1001-, 1002-, 1003-, ... 1017-).

In each of the worksheets I need to do the following:

Find&Select / Goto Special /Visible Cells only/Copy then Paste into a new workbook.

Each of the worksheets should be pasted into the same 1 workbook (so I will end up with a workbook with 17 worksheets containing the pasted visible cells).

I'm sure I could do the majority of this just by recording a macro - but how can I get automate it so that it goes in a range of specific worksheets (1001- to 1017-)?

Many Thanks

Burnsy