Bradley,

it's very easy to do this.
In your summary sheet, simply use a formula to link back to th
original worksheets.

eg In sheet1 you have a value of 1 in cell A1, 2 in cell A2

To total these in the summary sheet enter the formula
=Sheet1!A1+Sheet1!A2

Entering such formulae is also very simple.
When you are in the summary sheet, put in an = sign, then switch to th
other sheet(s) and place mouse over required cells. Then hit enter

Bradley,

  Yes, it is possible to link information from one worksheet to another.

  For example, starting on Sheet1 cell A1, type

  the equals sign, =, then
  click the the tab called Sheet2, then
  click cell B5 on Sheet2, then
  hit Enter.

  Assuming nothing was in cell B5 of Sheet2, then you should be seeing a
zero in cell A1 of Sheet1.  Go to Sheet2 cell B5 and enter a number, say 5,
then check Sheet1 cell A1.  It should also show a 5.

  The second part of your question is perhaps more complex.  For example,
do you want only totals for each employee to carry over, or do you want each
detail to carry over to the summary page?

   There are things like auto filtering a consolidated list that come to
mind as possible solutions to your problem, but from the first question it
seems that you may need more experience with Excel to have that be feasible
for you.