Excel Macro Question

[declasse]

Hi,

I'm hoping somebody can help me...

I have multiple excel workbooks in a folder and I would like to have a macro to take specific tabs from each file and insert them into a new master workbook.

The tabs I need would be named "Data", "Sheet 1" and "REM data"

Is there some code I can use to do this for me?

Thanks in Advance if anybody is able to help!

 

[Weaver]

Welcome to the board.

So you have a folder full of sheets and each one has 3 specific tabs. You need to copy these into a master sheet

Will all the sheets have all 3 tabs?
How would you want to rename the sheets as they get moved?
What version of XL are you using? (goes to how many tabs you can have in 1 workbook)

Broadly speaking, given answers to these questions, the answer is yes.

 

[declasse]

Thanks for the reply! I am using 2007 and 2003. So code for either is okay.

Each file will contain either "Data", "Sheet 1" and "REM data"

Never multiples though. So each file will contain multiple tabs but one of them will be named the above.

I am trying to learn but at the moment I really need to find some code I can use to do this.