Summarizing cell data using Macro

Hello everybody,

I need your help in showing me step by step how to summarize the data for each cell found in the 6o sheets. For example the data for B1, B2 as columns all next to each other. The file is melons.xlsm.
I have tried many codes but they are not working.

Thank you in advance.

I am having trouble understanding what the summary would be. Can you attach a file with the final results?

Actually these represent the ruselts I got from ORAC device which measures fluorescence every 2 minutes for two hours. I need to assemble the cells B1 under each other, B2 also, B3,C3 and so on. This will allow me to calculate the area under the curve for each cell after two hours.

By B1, B2, B3... you mean the sheet address or the references to the Small tables you have at the bottom of the orders?

I mean the cell number because they are organised from 1-9 in the top row and A-H in the column. So each cell is denoted by B1 or F5 depending in which row and column it is present in.

lol Sorry I am even more confused now. Can you provide a sample of your final results?