I've posted a few times on the same topic but I can't seem to figure it out,
so I'm going to try and re-explain and see if that helps :)

Ok I have a workbook, with several spreadsheets with all sorts of data on
them. Two of these sheets are almost identical except for the values in
certain areas. What I have is a sheet with locations in the Mid South,
Memphis, Jackson, etc. On row 10 I have columns A, B, C, and D merged with
the "Memphis" in it. The row below that is another location, same
format....skip two lines and more locations in the same format. Column E is
empty all the way down. Column F, I, L, O, R, etc have certain values in
number format in them next to each loaction. The other sheet that is near
identical to this has the same format and info on it, except the numbers in
them. The numbers on this sheet I want to reflect as a Year To Date number.
So when ever the first sheet numbers are changed (normally every Friday) the
second sheet will take that new number and add it to what was in ther ethe
week before. For example week 1 there is the number 5 next to Memphis....the
second sheet will reflect a 5 next to Memphis. Now in week two I change the
first sheet value. Now Memphis has a 12 next to it. So therefore the second
sheet will now have 17 next to Memphis...This will go on for the entire year.
In theory there will be 52 numbers sumed next to Memphis on the second sheet
(or the Year To Date sheet)....any macros that can accomodate for this?