insert column to auto-number for each item into two sheets

[abdo meghari]

hello
I would insert column A for two sheets and sequence of numbers for each item .

list1.xlsx
	A	B
1	BRAND	QTY
2	FS 195/65R15 EP150 THI	27410
3	FS 195/65R15 EP150 JAP	28445
4	FS 195/65R15 T001 JAP	29480
5	FS 205/65R15 EP150 INDO	25340
6	FS 205/65R15 MY02 THI	26375
7	FS 205/65R15 TZ700 JAP	31550
8	FS 195/55R16 EP300 THI	30515
9	FS 205/55R16 RE003 THI	24305
FS

list1.xlsx
	A	B
1	BRAND	QTY
2	BS 175/70R13 B25 INDO	230
3	BS 175/70R13 EP150 THI	123
4	BS 185/70R13 EP150 INDO	5675
5	BS 175/65R14 EP150 THI	6710
6	BS 175/65R14 B25 INDO	7745
7	BS 175/70R14 EP150 THI	8780
8	BS 175/70R14 MY02 THI	9815
9	BS 185/65R14 TEC THI	10850
10	BS 185/65R14 150EZ INDO	11885
11	BS 185/65R14 EP150 INDO	12920
12	BS 195/70R14 150EZ INDO	13955
13	BS 185/65R15 TC10 INDO	14990
14	BS 185/65R15 T005 INDO	16025
15	BS 185/65R15 T01 JAP	17060
16	BS 185/65R15 B250 JAP	18095
17	BS 195/60R15 AR20 INDO	2300
18	BS 195/60R15 EP150 THI	500
19	BS 195/60R15 T001 JAP	1535
20	BS 195/60R15 150EZ THI	2570
21	BS 195/65R15 MY02 THI	3605
22	BS 205/70R15 694 JAP	4640
BS

result

list1.xlsx
	A	B	C
1	ITEM	BRAND	QTY
2	1	BS 175/70R13 B25 INDO	230
3	2	BS 175/70R13 EP150 THI	123
4	3	BS 185/70R13 EP150 INDO	5675
5	4	BS 175/65R14 EP150 THI	6710
6	5	BS 175/65R14 B25 INDO	7745
7	6	BS 175/70R14 EP150 THI	8780
8	7	BS 175/70R14 MY02 THI	9815
9	8	BS 185/65R14 TEC THI	10850
10	9	BS 185/65R14 150EZ INDO	11885
11	10	BS 185/65R14 EP150 INDO	12920
12	11	BS 195/70R14 150EZ INDO	13955
13	12	BS 185/65R15 TC10 INDO	14990
14	13	BS 185/65R15 T005 INDO	16025
15	14	BS 185/65R15 T01 JAP	17060
16	15	BS 185/65R15 B250 JAP	18095
17	16	BS 195/60R15 AR20 INDO	2300
18	17	BS 195/60R15 EP150 THI	500
19	18	BS 195/60R15 T001 JAP	1535
20	19	BS 195/60R15 150EZ THI	2570
21	20	BS 195/65R15 MY02 THI	3605
22	21	BS 205/70R15 694 JAP	4640
BS

list1.xlsx
	A	B	C
1	ITEM	BRAND	QTY
2	1	FS 195/65R15 EP150 THI	27410
3	2	FS 195/65R15 EP150 JAP	28445
4	3	FS 195/65R15 T001 JAP	29480
5	4	FS 205/65R15 EP150 INDO	25340
6	5	FS 205/65R15 MY02 THI	26375
7	6	FS 205/65R15 TZ700 JAP	31550
8	7	FS 195/55R16 EP300 THI	30515
9	8	FS 205/55R16 RE003 THI	24305
FS

thanks