How to compile all data in one sheet on VBA?

[Faezah]

Hi all,

Need help on VBA codes that can be used to pull out data from various excel spreadsheet into one final compilation of data in one spreadsheet?

Thanks.

 

[My Aswer Is This]

The term Spreadsheet is a term used in the 1980's and earlier.
So when you say spreadsheet do you mean Workbook or Worksheet.
And we would need more information about how you want all this data compiled into What workbook or worksheet.