Absolute Reference

[kumara_faith]

Hi,

I have a budget template as follows:

Excel Workbook
	B	C	D	E	F	G	H
2	Expense Code	Input Code 2018	Input Code 2019	Input Code 2020	Input Code 2021	Input Code 2022	Budget 2018
3	7001	250	250	250	250	250	250
4	7001	350	350	350	350	350	350
5	7001	120	120	120	120	120	145
6	7001	360	360	360	360	360	875
7	7001	653	653	653	653	653	653
8	7001	150	150	150	150	150	256
9	7001	231	231	231	231	231	145
10	7001	254	254	254	254	254	965
11	7001	254	254	254	254	254	254
12	7001	547	547	547	547	547	547
13	7001	587	587	587	587	587	587
14	7001	521	521	521	521	521	521
15	7001	154	154	154	154	154	254
16	7001	54	54	54	54	54	54
17	7001	254	254	254	254	254	254
18	7001	587	587	587	587	587	587
19	7001	57	57	57	57	57	57
20	7001	511	511	511	511	511	511
Sheet1

I need the cells in yellow in the column Input Code 2018 to 2022 to return the values in the Budget 2018 accordingly across multiple sheets at once

What I am doing right now is I am making the cells in column Input Code 2018 (only the yellow cells) to reference column Budget 2018 and then dragging across from column Input Code 2018 to Input Code 2022 for each row for the yellow cells.

I have about 20 sheets in the same workbook that I need to do exactly the same thing. After referencing the Input Code 2018 (yellow cells) to Budget 2018 column, is there a way to simultaneously change the cells in yellow for Input Code 2018 to absolute referencing simultaneously for all the sheets?

Appreciate all the help.