Auto Update Text Box Cell Reference
 

I have to manually update cell references in text boxes as data shifts
(across columns) daily in a separate workbook. Is there a way to
automatically update all of the cell references at once using VBA?