extract data from multiple worksheets and save to the respecting workbook

Hey you all,

I am completely lost here and I couldn't find anywhere how could I fix my problem. I hope someone out there can help me.

I have a workbook containing original information for all countries involved. Each months data is saved in a separate worksheet. I want to create new reports for certain countries, and include all the info for the year into another workbooks single sheet.

What I want to do is: 1.create a new workbook for every country 2. transfer all the data where shipment end location is this particular country into the worksheet (7th column)

I've already created a range to loop throught this list and create a new workbook for each. My problem is how to loop throught the worksheets, and coppy over the data I need.


My code works perfectly if I enter the code in a worksheet, but unfortunately the data set is too large to be saved into single sheet.

I've uploaded a sample workbook, with the code written so far. If you have any other questions, please let me know.

I'd be very gratefull for any help! Thanks a lot in advance!

Regards,
Anitra