MamaHart,

Let us assume that you current sheets have tab names called 1, 2, 3.. 12.

Let us also assume that the data you want exists in Row 1 and Column A, B, C
(in the individual sheets).

Insert a new worksheet (Insert, worksheet)

Insert headings in your new sheet in row 1 and Columns A to J (if required).

In Row 2, Column A enter = (equal sign) then using your mouse go to the
sheet that you need to bring the data from and in the cell that has the
figure you want hit enter.

You should now notice that the figure from that sheet will now appear in Row
1 Column A.

Repeat the above for all 12 sheets and you should have a MASTER sheet.

For your information with your cursor in row 1 column A, look at the formula
bar it will read something like =sheetname!cell number.

HTH

"MamaHart" wrote:

I have an Excel spreadsheet that has pages 1-12, which is a two year budget
of items per category (there are 12 categories). I want to make a MASTER
sheet that includes the total row of each of the 12 sheets. How do I
populate the fields on the MASTER sheet from the other pages?