Program (VBA) to test 50x60 table

Hi

Select any tab but the machine #1, then select the machine #1 tab and it will fire off the macro.

rylo

Unless I'm doing something wrong, I don't see any change in the sheet "Machine #1".....
And since I am not VBA expert, it's hard for me to decode what it is supposed to do

But in the example, I should get in the sheet "Machine #1" Tool 1 in the cell B6 and Tool 2 in the cell B10 because Tool 1 is loaded on Machine #1 (Mach #1) in the whole row AA5 to CA5, and Tool 2 is also loaded on Machine #1 (Mach #1) in Row 6 from Jan 2013 t Jun 2013, then from Jan 2014 to Jun 2016 (in the sheet Yearly to Daily)
And Tool 3 should not appear in the sheet "Machine #1" because this tool is loaded on Mach #4 only (whole row 7)
My gosh, I hope I am clear...!!