Formula
 

Ok, I have a workbook that consists of about 40 sheets. It tracks our daily sales as a team.
The first sheet is a total for everyday of the month, and obviously the next 31 are per day, and have different rows as to per representative.
Now, the last 6 pages are per rep, and each row is per day.
How can I take a value for a cell on page, say 40, and have it equal, say...H6...and then be able to drag it down and have it adjust per SHEET and not per ROW??
I am not uber lazy, but for 12 months, and 31 days, and 6 reps (minimum) typing this in (two different columns also) is a little repetitive, and has me loathing this project.

Any help would be appreciated!!