I have 20 worksheets in EXACTLY the same format in one workbook.
There are 200 numeric fields in each sheet.
I want one SINGLE consolidated sheet with each field "summed".
What is the easiest way to consolidate?
I am aware that Excel has a consolidation function but that seems to force me to repeat keying tasks multiple times. i.e. for each of the 200 numberic fields I would need to repeat the same actions 20 times (i.e. one for each sheet)