Moving columns Automatically with Frozen Panes

[vapulabis]

name | dated columns incrementally increasing->


---------------------------------------------------------------------
name 1 |
name 2 |
name 3 |
name 4 |

the name column is a frozen pane column and the dated columns can move left or right depending on which date ( Row A ) you want to view for the information the table holds per person in column 1.

when I open the spreadsheet, is there a way I can use today's date and search for today's date in Row A, then make the table automatically slide left or right to make the selected column the first column after the frozen pane?