Is there a code I can apply in the page header that will read the mininum and
maximum date in a range of cells?

For example:
I would like the page header for some worksheets within a workbook to read
"Data Report from 'minimum date here' thru 'maximum date here'.

So, let's say that I had a pivot table that is refreshing the summarized
data from worksheet1 that has dates in some cells. I would like to refer
back to that so I can automate a date range in the page header for my pivot
table. Is this possible?