How to make a cell value dynamic when the referred value changes?

[BNCOXUK]

Hi, I just have a quick question.

In cell A1 of Sheet2, the value is static and made as: Sheet1!B:B, which means that it refers to column B of Sheet1. As this is a static text, it will not change even when new columns are added before column A of Sheet1. How do I use a formula to make cell A1 of Sheet2 automatically update when new columns are added in Sheet1? For example, if a new column is added before column B of Sheet1, then cell A1 of Sheet2 needs to be changed to Sheet1!C:C.

I know named range can make this happen, but I prefer to use a formula to accomplish this.