Horizontal look up and vertical return (Complex)

Hello
VBA Code - I'm being told this is possible but very complicated

Can a code be written so the following can happen, I want to enter the shift, date, and machine number into the Monday scrap tab, it then looks at the Monday tab in col F and returns the part number in a horizontal way, as to the expected data

I have could have up to 16 machines running, so, I need to enter the data highlighted in yellow and it returns as to the attached expected data?

Can something be written so it then looks at the Monday tab and returns to the attached results that I can enter manually?


please see attached to help explanation

Paul

that works very well...

thanks for your time
Paul