Macro-Arrange dropdown selections from multiple tabs+paste them in same order in new tab

Hello Forum,
I introduce myself as a Sr. Product Quality Engineer. I do have some experience w/ macros, where I built a system to track 10 assembly lines for daily performance, scrap and quality metrics. So most of my experience is in writing macros for selection, copy, pasting, opening/closing/saving, updating, etc. I’ve been following this forum since a long time and I’ve got so many hints, which made my job easier. Though, the following question is a new challenge. Please see the pdf attachment

Please let me know if you have additional questions or any concerns with my post.