I have master excel file with some of sheets names are ("abc", "def", and "ghi"). In the same folder as master excel, there is 1 folder named 'Data' where inside it there are 20 excel workbooks which also has same sheet names ( "abc", "def", and "ghi"). I want to have vba codes inside the master workbook to copy paste and consolidate all values in each of these sheet names ("abc", "def", and "ghi") from 20 excel workbooks to master excel file.
I can provide with dummy data if that's needed.
Thank you!
I can provide with dummy data if that's needed.
Thank you!