VBA code to copy data from multiple workbooks and paste into master workbook

[Sunns]

Hi everyone, I'm new to VBA and its so hard for me to write a code to copy data from different workbook and paste into master workbook.
Hope someone helps me with this,

I have few workbooks which contains the results of dyno testing of different engines and I want to do some comparison, hence I want a code which copy specific row from those workbooks and paste into master workbook.
Also in master, I've created different sheets by renaming it with specific model number so it will paste data into associated sheet.

So i want that, it goes through all workbooks and if the branch "East" in cell "AY9" then it will go in cell "AC7" and find that same value or nearby in column "E" and copy that whole row and paste into master workbook. In master workbook it will look for the sheet name for eg. "20V4000C22" which mentioned in "AY1" cell. After finding the sheet it will paste serial number first in column "A" and along with copied data.

However, for west.

It should look for value in cell "R10" instead of "AC7". and rest is same as above mentioned.

I know its bit tricky, but I hope someone would be able to help me with this.

Regards