Copy value from one sheet to another based on condition

Originally Posted by Marion59

Management wants to see the figures from week to week and that is why I want to copy data from one sheet to another.

Management can't observe 52 sheets at one and the same time. They presumably want to see a particular week and then after that see another week. All of which can be done by either Grouping the Pivot Table by week, or by filtering a specific week.

Or if you don't want to use a Pivot Table then use an Advanced Filiter and a criteria variable cell to extract the records for any particular week to a template sheet. What's important is to be able to see the records for a particular week. Where those records exist at the time they are seem really doesn't matter.