Writing updated info across several worksheets

I think I understand what you're saying. Ingeborg is right though, structured this way is backwards.

If the data you're looking up is in a Table, then you can reference it and never worry about it. My assumption is the data being entered on these other sheets isn't in a Table, and keeps growing, thus you don't always have the most up-to-date range to reference. The easy fix is to make them into Tables. Can you do that? If not I would use a named range. Of course I recommend a good data structure, like Ingeborg suggested.