See the Comment cell for the Cell formula of D1, drag down of D1 cell to auto fill, formula will enumerate like “==C2$+"!B[1]"“, which will refer to the B1 cell in the 2nd sheet.
Drag down of F1 cell to auto fill, formula will enumerate like “==E2$+"!B[1]"“, which will refer to the B1 cell in the Sheet2.
Drag down of G1 cell to auto fill, formula will enumerate like “==”B”+C2$“, which will refer to the B2 cell.