Copying data from multiple workbooks

Dear all,

Greetings of the day..!!!

I m looking for a macro for the below requirement.

There are multiple workbooks in a Folder, all workbooks have multiple worksheets which contains data.
for example

In 1st worksheet (EMP Information)

EMPLOYEE NAME : XXX GRADE: XXX
EMPLOYEE NO: XXXX DESIGNATION: XXX
LOCATION: XXX DOJ(DD/MM/YYYY): XXX
DEPARTMENT: ​XXX FOR THE PERIOD: XXX
MANAGER'S NAME: XXX

In 2 worksheet (Goals Review)

need to pull the data from the cell J16 to J31

All the Data should be in this COLUMN wise format

EMPLOYEE NAME EMPLOYEE NO DEPARTMENT MANAGER NAME ..............

XXXX XXXX XXXX XXXX ........

YYYY YYYY YYYY YYYY........

Please help me out with macro

Thanks in Advance.

-Anvesh