Put Cell Value in Column

HI

I got the the table as attached.
I am now not sure How I get these values into the combined data tablee. I have two workbooks in my folder one for MAN and one for WPA that I can combine. The attached table shows the values of the named ranges from those files. How do I now get them into three columns in my combined table.
Please note eth parameter values for MAN and WPA could be different.

I am thinking of creating three new columns, renaming to match the column names on the attached and then do a Merge ?

Allister

image