i have 7 work sheets that are all have information that is going on a master
sheet. i have a the equation written that adds the sum of say cell A1 on all
7 sheets. but when i copy and paste it it doesn't update the row number
(i.e. instead of being the sum of all A2, it just pastes all A1 info). How
do i fix this!!?? Help