Search separate sheets to find matching model numbers and return results in another sheet

Hello Experts!

I have a need to search through three separate sheets to find common model numbers listed in project lists and return the data into another sheet. I've attached the general sheets and examples of what I'm looking for.

The "PROJECT MATCHES" sheet shows how I need to compile the matching data.

The other three sheets are where the project information comes from.

Looking for a VBA routine to loop through each sheet and return data.

Thoughts or better suggestions?

Thank you,
Jay