simple data capture across sheets

[lancaner]

Hi,
I'm sure similar payroll questions have been answered – I just can't find one to suit. I'm trying to help a friend by setting up a payslip / payroll tracker with excel. I have the payslips, and we'll use them to enter data on a weekly basis from the field. I just need to work out how to pull the data from each weeks work into a running total

[TABLE="width: 500"]
<tbody>[TR]
[TD]Day
[/TD]
[TD]Rate
[/TD]
[TD]Hrs
[/TD]
[TD]Total
[/TD]
[/TR]
[TR]
[TD]Mon
[/TD]
[TD]30
[/TD]
[TD]38
[/TD]
[TD]1140
[/TD]
[/TR]
[TR]
[TD]Tue
[/TD]
[TD]etc
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Etc
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Gross
[/TD]
[TD][/TD]
[TD][/TD]
[TD]1140
[/TD]
[/TR]
[TR]
[TD]Tax @ 13%
[/TD]
[TD][/TD]
[TD][/TD]
[TD]148.20
[/TD]
[/TR]
[TR]
[TD]Nett
[/TD]
[TD][/TD]
[TD][/TD]
[TD]991.80
[/TD]
[/TR]
[TR]
[TD]Super9.25%
[/TD]
[TD][/TD]
[TD][/TD]
[TD]105.45
[/TD]
[/TR]
</tbody>[/TABLE]


I have 40 tables similar to the above per week (per sheet), one for each employee. The season goes for 12 weeks so I have 12 tabs/sheets along the bottom. The above sheets double as a printable payslip.

I want to be able to pull data from each table and each sheet into one sheet that captures a running total of 'Super', 'Tax' and 'Nett' amounts as we go. I can go through and manually input ='sheet2'!F58 but I feel like there must be a better way.


Any ideas, or pointers would be much appreciated!
Thanks