Tried posting this on the Function Forum. A lot of looks but no responses. Thought this might be a better forum.

I have a spreadsheet I use for recording data on each day of lobster diving.
The Master Sheet (Sheet1) has 15 Columns. Column A has a list of 200 locations that are each identified by a unique text string. If locations are added they are given a unique text string in Column A

Columns B thru H contain other descriptive data that may be edited but are always attached to column A.

Columns I thru O are used to record observations each time the location is visited. After a day on the water the observations are recorded on “The Master Sheet: (Sheet1).

I have written a macro which copies the sheet to (Sheet3) displays only the data from the locations visited that day. (Normally 10-20) and deletes all the locations not visited. It gives (Sheet3) a unique text string name that represents the date of the trip. It clears all the data imputed on the “The Master Sheet” and I am ready for the following trip.

Tomorrow, etc. the process repeats and the locations visited become (Sheet4) and so on and so on.

(Sheet2) is designed to accumulate the sum from Columns M and N on an ever increasing number of sheets. (Sheet2) has each and every location that appears on “The Master Sheet”. (Sheet3) thru (LastSheet) contains only some of the locations.

How can I make (Sheet2) accumulate totals?

I am not sure whether a formula using a combination of vlookup and sumif is the answer or whether I need another macro to do the work of accumulating the totals.

Any suggestion or guidance would be greatly appreciated. Sorry for the long post but I felt that a detailed explanation would return the best results.

[email protected]