Grabbing worksheets from various workbooks

[kchm_2000]

Hi,

I have a code that aims to grab various worksheets from various workbooks based on worksheet names. Basically it takes the workbook names from col b and worksheet name from col c to import them in. however I am having an error on this line below:

ws.Copy after:=wbkDest.Sheets(Sheets.Count)

I have attached the relevant files with Test and Test2 being the files to be copied whilst MAIN is the consolidation file. Currently I am using excel 2003 for this macro. Thanks for anyone's help in advance

Please Login or Register  to view this content.

[TMS]

Try this:

Please Login or Register  to view this content.

Regards

[kchm_2000]

thanks a lot it works now

[TMS]

You're welcome.