I have this workbook I'm using for work. I have one sheet where I enter information and then some other sheets which uses the information in the first sheet. The problem is that I sometimes have to add copies of a sheet and updating the cell references to point to the correct information manually is exhausting.

The only thing that changes in these cell references is the column. The row always stays the same. For example I add new information, in the info sheet, in column H and I in the rows 10 through 26. In the new sheet I have to change 26 cells where the only change is the column.

Is there some way to automate this or at least make it easier?