If you are familiar with the Connections feature in Excel, you can import another worksheet data into current workbook, and your imported data will be updated with the original data automatically.

Go to click Data > Connections
In the Workbook Connections dialog, click Add button, and in the popped out Existing Connections dialog, click Browse for More button,\
And then choose the workbook that you want to export its data to current worksheet.
After choosing the workbook, please click Open button, and select one worksheet that you want to use.
In the Existing Connections dialog box, click the workbook that you are added just now, and click Open button.
And in the popped out Import Data dialog, choose one option you like from the Select how you want to view this data in your workbook, and then choose one the existing worksheet range or a new worksheet to put the data.
Then click OK, the data from another worksheet has been imported into your specified worksheet

I hope these steps will be helpful!
Matt Henry