I'm currently using excel 2003 and am trying to figure out how to update
multiple worksheets within the same workbook by just inputting data into one
sheet. Ex: I have four sheets in the workbook. One is an overall tracking
sheet and the other three are tracking by specific area. I would like to fill
out the main sheet and then have that information automatically updated inot
one of the other three sheets based on certain criteria. Please give any
input.