I am making a log for a quality control area, there are multiple inspectors and they all have their own tab in the worksheet. I want to be able to take all the data from those tabs and consolidate it into another tab called "Summary". The data starts on row 10 and the all tabs have the same header including the summary tab. Also there is a summation line at around line 200 that I don't want to be copied into the summary tab, if it has to be removed that would be fine. The data is in columns A to Z. Any help would be greatly appreciated
Thank you
Here is the worksheet.
Bookmarks