Macro to extract data from multiple workbook & worksheet

[patng69]

Hi,

Can anyone help me this......?

I need to extract data from different workbooks and within the workbook has many worksheet named 29 Jul, 30 Jul and 31 Jul. All the data format are the same as I want to make he copy easy.

Can the macro extract information from within the main sheet?
Meaning to say, I will create a worksheet name "LIST" then column 1 (Item number - 1,2,3), column 2 (File name - xxx.xlsx), column 3 (Full Path - z:\testing\), column 4 (Data sheet name - 29 Jul), column 5 (Data Range Start Cell - start of the data to copy), column 6 (Data Range End Cell - End of the data copy), column 7 (Copy to Sheet - Master Data) & column 8 (CopyToLocation - E4)?

If anyone can help me ????