Copy data from several workbooks to one master workbook

Hi!

I have multiple Excel workbooks (with different names) and I want to copy some data from column A and column C (the cell names/reference are same in all the workbooks). I want to paste this data to 1 master excel file such that the data goes to the next available row instead of overwriting.

Can you please tell me the steps to record a macro for this purpose. I do not know how to write the VBA script.
From Company ABC file to Master file.
A1 to go to A4;
N5 to go to B4;
P5:P12 to transpose and go to C4:J4.

Such that the data from the next Company file should go to row 5 in the Master file.

Seriously need your help. My job is in danger!!
Please please respond quickly.