在不同的Excel表格中更改多个数据条目

I need to change the data in multiple cell sheets at the same time. The problem is, they aren't the same cell and they need to be automatically updated. For instance, I need to edit a value in sheet 1 A1 that will be automatically updated in sheet 2 B1. Is there some way to easily change this?I need to change the data in multiple cell shee