Show List of items from cells in one worksheet in another worksheet

Hi,

Please find spreadsheet attached which is essentially a production schedule.

I am trying to get the contents of column D (which relate to Column A) to show in a corresponding worksheet.

So for example I would like All items from week 19/20/21 (red box/blue box etc) to appear in worksheet wk 19/20/21. Not as a total quantity but as a list as they appear in Column D.

The tricky part is that this needs to be automated so that if I re-organise Sheet 1 then worksheets wk19/20/21 will update automatically.

This may be more simpler than it seems to me.

Many thanks for looking

Teylyn

Thank you so much for this you're a star!
Worked immediately and has solved my problem

Thank you