I have several worksheets containing the same columns and data for different
entities. I need to create a summary worksheet that pulls all the data into
one 'total' worksheet and gives me the ability to 'refresh' when I enter
changes into my individual worksheets. I am just learning functions. Am I
best to use Pivot Table, Consolidate or summarize some other way?
Thanks for any help in advance!