A quicker way collate from multiple tables?

[border.studios]

HELP!

I am trying to create a spreadsheet/workbook to keep track of my photography sales at different shoots over the year.

I need to be able to record the sale of multiple pruducts and packages at each shoot, and I would then like to collate the information on running table.

My issue, is that I have the expectation of completing around 50 shoots over the year and I would like to be able to create space to input the data without having to write long long long long formulars in the collation cells (ie adding together the info from 50 different tables)

I am wondering if it is possible to create one 'template' for the info I want to put in from each shoot and then tell the collation table where to get the data from that table, and then copy the 'template', either onto different sheets, or elsewhere on the same sheet, and have the collation table automatically update to include the new data cells?

I am 100% self taught in excel, so have only ever gathered the basic information I need as it becomes necessary :-(

Hope this makes sense.