I thought this would automatically update the data every day. <<

The QueryTable method does have a "RefreshPeriod" property. For
example, if you had created the table with this in the "With" group:

.RefreshPeriod = 60

....then it would automatically refresh the query every 60 minutes. I
would think you'd run into timing issues if you made the 1440 minutes
though, since the start time might be when you open the workbook.

You could go into each query table and edit the "Data Range Properties"
and change it.