Question: how to transfer data from one workbook to another automatically in excel?
Answer: In source worksheet, select and Copy the data that you want to link in another worksheet.
Now in the destination worksheet, Paste the data where you have linked the cell source worksheet.