The fastest way to loop in 2 tables

Hi,

i have source table like here:

Screenshot_6.png

The goal is to loop through all rows and for specific column names provided in column B populate values in tables in specific sheets.
So for Tab1 Scenario we will get the result like here:

Screenshot_7.png

How to do this in the best possible way ?

Best wishes,
Jacek