Question

to summarise and report from separate worksheets you can

Answer 1

Answer:

to summarise and report results from separate worksheets you can consolidate data from each sheet into master worksheet the sheets can be In the same workbook as the master worksheet or another workbooks. when you consolidate data, you assemble data so that you can more easily update an aggregate as necessary.