Copy particular columns from one file to master file with condition

[siddi20]

Please Help!!!
Task is to consolidate 2 files(A and B) into Master file. I have written code below but its tkng all fields.I only want

Column 1 - File Name ( name of A/B)
Column 2- Gender/Value 1 .If Gender is M then it should show Value 1
Else I should show Gender value

Column 3-Value 2
Column 4 - Region value

I have filter the data in A/B files country specific. I will really appreciate if someone can help.

Attaching the files for reference