Try a variation of this example:

A1: =COLUMNS($A:A)
Copy that formula across through H1

That will generate a series of digits from 1 through 8

If you delete any of those columns, the numbers automatically change.
For series that start in another column, just change the initial column ref...
eg C1: =COLUMNS($C:C)

Is that something you can work with?