Copy data from one Workbook to another

Hello,

I have to save data from one Sheet 1 of Workbook 1 to Sheet 1 of workbook two.
EX:
Sheet 1, Workbook 1
Date Name Salary
1/1 ABC 100,000
1/2 DEF 200,000
No predefined row number but column will be pre-defined

Sheet 1, Workbook 2
Date Name Salary

The data needs to be copied to Sheet 1, Workbook 2 (saved on a shared path)
also, data cannot be written over. Pasting needs to be done from the blank cell.