Copying Data

[cool.chatbot]

I have 30 excel workbooks opened on my pc, and I want to copy a particular worksheet called "Target" from all these workbooks.

I want all the data to appear on a new single worksheet.

For eg:

Wb1.xls contains worksheet called Target
Wbqw1.xls contains worksheet called Target
Wbq.xls contains worksheet called Target
upto 30 sheets

Result:

Result.xls would contain worksheet called Mission which will have all the data.

[davesexcel]

Do you want to loop through all the workbooks in a folder and copy and paste the data from "Target" sheet into on specific worksheet?

[cool.chatbot]

yes. I want to copy a particular sheet from all the workbooks in the folder.

I want all the data to appear in a single worksheet (top to bottom)

[davesexcel]

Check out these threads
http://www.excelforum.com/search.php?searchid=2874155

[cool.chatbot]

not able to acess the provided url. please post the solution