Hi All,
I am looking for vba code that allows me to collate data from varying excel workbooks, however there are multiple sheet names within each workbook (of varying amounts) and the sheet names are different. I need to collect the raw data from these workbooks which do not always follow a set...