Hello, I am trying to consolidate data from the same sheet in multiple files into one single table. The source files are structured similarly, in a tabular format(not an actual excel data table). I'm interested in pulling together the data that starts in row 4 (cell A4-E4), additionally, I'd like to pull in the last column in the table (the header in that column is "Source", but it varies which column it is from file to file. It isn't necessary, but it would be helpful if the consolidated data table had a column which identified where the data came from (either file name or another unique ID). Any thoughts/comments/suggestions would be greatly appreciated!
Also, please keep in mind that I can have all of the source spreadsheets (files) in one folder path.
Also, please keep in mind that I can have all of the source spreadsheets (files) in one folder path.