Can sombody help me for following

I have 3 workbook in a folder,I want to extract the data from 2 work book and put it in to 3rd work book

Data available in 2 workbook are in row wise and I want in column wise in 3rd work book

When user enter the name of the person data from other 2 workbook will be consolidate in 3rd workbook

Files are attached

Eg for Person AAA 4 data points available for Education details but for BBB there is 6 data points available .so While consolidate row should adjust accordingly and should be border.

Physical details will be below Education details.

Waiting for Reply