Refreshing pivots with week ending dates

Hello,

In the attached file I need to sum the lines of goods in, against the week it comes in. So, for example
In the data tab any goods received between 01/01/2023 - 06/01/2023 will be for Week 1.

As the data already includes these lines in week 2, I have created a separate pivot for week 2 data, anything from 07/01/2023 - 13/01/2023

The issue is that this happens manually. I have gathered the week ending dates for 2023, and created a drop-down list which automatically retrieves the dates.

Would there be a way on combining both to automatically gather the goods in relating to the month/ week ending dates.

Or any process which can gather this, while also leaving it easy to update month on month.

The same would also be needed for storage, if possible, but this one is not too bad.

Hi,

Thanks this looks really good, will check everything now!