I have a Summation sheet that needs to collect and total data for staff across 26 other sheets. They are all formatted the same and the data needed sits in the same column on all 26. I'm using their Employee ID # as a reference point since it's unique to each employee. I've tried but failed with Index/Match and am not sure how to use Indirect to help pull the data together
The 26 sheets have the data in data Tables uniquely named.
I'm using Excel 2016
The 26 sheets have the data in data Tables uniquely named.
I'm using Excel 2016