Moving average for fixed number of cells with and without data - newbie'ish! |General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi all, 

I currently have a moving average equation working properly with the ability to change the intervals of which is finds the average. This is being done on a month to month basis (separate worksheet for each month in one workbook) for volumes. However, we need a moving average that will cross over each month. For example, right now I cannot find the moving 7 day average starting back from 10/2/2022 because of the separated worksheets.  I have a master dashboard worksheet in the workbook and I was able to use "Paste Link" for each month to pull the total volume per day into this master sheet, but I cannot get my moving average to work because it pulls from the last cell (#368) and upwards, which currently are all zero/blank.  I think it is because of the "paste link" function as my other worksheets are able to calculate despite how many rows are blank because it pulls from the last entered value.

To add- this excel document is being run in a Microsoft Teams page which not have the power   consolidate functions.