I have a basic understanding of VBA and am trying to create a macro that will consolidate all worksheets within a workbook into one tab.
I have the found the following code which consolidates all the data but I need it to also copy the name of the worksheet alongside the data from that sheet -...