Updating Existing Worksheet

Hello, everyone I hope everyone's holiday's are great. I want to thank everyone in advance for their help with this situation I am having in excel.

I have a workbook where I have data from companies listed in the first worksheet, calculations in the second worksheet, and summaries in the third worksheet. I have created a fourth worksheet to add data from the previous year from the companies as it comes in from their inspections. The problem is after all of that year is finally inputted in the worksheet and the updates are completed than I want it to over-ride the first worksheet. Keep into account that all of the data is not being updated just certain areas of the worksheet which is probably about 200 rows out of the 675 rows that are there.

Is there a way to do this without copy & paste that seems tedious. Is there any insight into this dilemma that I have.


Any suggestions are welcome and thank you fro them.