Program (VBA) to test 50x60 table

Hello,

I am working on a file and need some help
In the 1st tab ("Yealry to Daily") , I can define up to 50 tools (from B5 to B54), and allocate those tools on machines per month (from AB5 to CH54)
So it can be on 1 unique machine for the 5 years, or 1 machine for 6 months, then another machine for 1 year, then another one or the previous one, etc....(but usually not more than 3 machines per tool)
Anyway, the attached file is for example, but the final one wil have 13 machines. So with 50 tools and 13 machines, I do not expect to have 1 machine with more than 10 tools. This is why the sheet "Machine #1" has only 10 possible tools

What I would like to do in "Machine #1" is to get in the pink cells all the tool(s) that are allocated on Machine #1, meaning "looking" in the table in "YEarly to Daily" sheet if there are cells with the name "Mach #1"
If there are, the names of those tools should be copied in the pink cells. In my example, I should see Tool1 and Tool2 (in cells B6 and B10) - but not Tool3 since it is not allocated on Machine #1 anytime across the 5 year period (Tool 3 is on Machine #4)

I think I need to do some sort of Loops, but I dont know how to do it....!!!

Thanks in advance