Automatically select new data when refreshing Pivot Table

This is probably simple and may require some VBA, but I have (2) Pivot Tables that are pulling from 3 simple columns. Every afternoon I want to run a report. The report consist of a date and percentage. The problem is when I refresh my Pivot Tables it doesn't select the new date automatically. If I set it to Select all, then it pulls the blank data as well and doesn't chart the way I would like it to. Can someone take a look and see if you can help. I have attached a dummy sheet as an example. Thanks,

Use dynamic named range as your pivottable source.

With your set up named range formula.
=Sheet1!$B$1:INDEX(Sheet1!$1:$1048576,COUNTA(Sheet1!$B:$B),COUNTA(Sheet1!$1:$1))

Name it something like "pvtRange" and use F3 in Change PivotTable Data Source->Table/Range: to pick it from list of names.

I am afraid you've lost me on this.

See attached. There was mistake in previous formula (since you have Column A blank, you need to add 1 to column in index formula).
=Sheet1!$B$1:INDEX(Sheet1!$1:$1048576,COUNTA(Sheet1!$B:$B),COUNTA(Sheet1!$1:$1)+1)

You can find detailed tutorial on dynamic named range in link below.
https://exceljet.net/formula/dynamic...nge-with-index

When you refresh PivotTable it will automatically recalculate and grab latest data.

You can check the formula in Name Manger (in formula ribbon).

Alternately you can convert data source range to table.