Link formula to a range of cells based on a condition

Hi Jen,

I have a spreadsheet for budgets and once I have populated the data from ERP system. I need to link the a formula to a range of cells within the same row where the account code is = 3999. The formula is ='Sheet 1'!I10

Example, IF account code in Column B =3999 is found at row 27,then on the same row across a few columns say Colum I:0, I need to copy the fomula ='Sheet 1!I10 in cell I27, then pull it across to Column O and the color the cell orange and lock the cell too.

So cell I27 will have this formula = 'Sheet 1!'I10
Cell J27 will have the formula = 'Sheet 1!'J10
Cell K27 will have the formula = 'Sheet 1!'K10 etc

Once the cells the filled in, those cells I27 to O27 needs to have fill color as orange the cells to be locked too.

Once the sheet is protected those cells also become protected.

Can these codes be dynamic in the sense, on workbook 1 the account code 3999 in Column B could be at row 27, whereas in workbook 2 it could be at row 36 .

Your guidance will be appreciated.

Regards


AJ