Macro to Consolidating data from multiple workbooks and worksheet into a Master File

[patng69]

Hi,

I need help on to write a macro to help extracting data from multiple workbook and worksheet.
As I have many file to copy from and their file name are different and also within the file there many worksheet (or tab?).


Is there a way to do it?

Hope to hear from you soon.

Thanks in advance.

 

[Binning]

There's a way to do it provided there is a logic behind the names for the workbooks and sheets within (unless you just wanted to extract the data from all sheets on all open workbooks, which could be quite easy).

Do you want to consolidate all sheets in all workbooks into one master sheet?