Yes ... what you are asking can be done.

Are the existing worksheets that need to be updated all located in the same workbook ? If not ... can they be moved to the same workbook (makes it a lot easier to work with).

To get an accurate answer it would be best to post sample workbooks with just a little data to work with. The data does not have to be anything confidential.