I have 6 worksheets with the same information for different age groups, but I
want each branch to send me a summary sheets so that it it easy for me to
make a large overall summary of the company.

Is it posible to have a system where data from the 6 worksheets will
automatically save to the summary worksheet? (I only need some of the
columns of data in the summary)

Thanks
Steve