Combine 2 sheets into 1 that will update w/new data

[Ms. Von]

I have two worksheets that data is enterd onto twice a month each wprksheet
has a set of columns that summaraizes and performs calculations on the data
enterd. I would like to combine the summarized columns into one master sheet
and have them be updated when data is enterd bi-monthly onto the primary
sheets.

 

[Nate]

I think this will work for you:
http://office.microsoft.com/en-us/excel/HA010548301033.aspx

 

[Ms. Von]

Nate, I do not want to combine them to print them i think you mis-read my
question i want to combine the data from two separate worksheets in the same
workbook INTO 1 WORKSHEET -- THAT WILL UPDATE ITSELF -- WHEN NEW DATA IS
ENTERED ONTO EACH OF THE INDIVIDUAL WORKSHEETS!!