These two Excel functions make stacking data from multiple sheets too easy
www.makeuseof.com/these-excel-functions-make-stacking-data-from-multiple-sheets-easy/
VSTACK – For data that needs to be ready for analysis
HSTACK – Best for side-by-side comparisons