Not sure what you really want, but attached is an example how to get what you asked
I used Defined Tables instead ordinary ones.
From your example it remained unclear, how you'd handle week numbers starting from 10th one! In my example, it will be "Week10". In case the week values in your table were markers only, and real entries for them will be something different, you have to make proper corrections to formulas. Btw., I'd use numbers in format "yyyyww" instead (1st week of this year would be 202301). This allows to have data from several years to be entered into your table without problems!
As i did write at start of this post, I can't see any gain you can get from this. In table on Sheet2, i'd have columns where weekly counts for every of reasons would be calculated instead.