I'm trying to build a spreadsheet that averages Blood Glucose readings.

I have the formulae for the averages, weekly, monthly and annually.

January is on one worksheet, February on another and so on.

I'm hitting a brick wall when I try to collect the monthly data from each month and place it in a YTD worksheet.

There will be 13 worksheets under one file.

I'd like to have YTD be dynamic and update each time I input new data.

This is for my own use.

Thanks in advance.