The Data that I use for my pivot table keep changing each week. Weekly, I
copy and paste data from another excel spreadsheet into the workbook that
contains the pivot table. Each week I go in and rename the data range before
I refresh the data. Is there a way that I can perform the data refresh on the
new data without worrying whether this week the data contains 25 rows or 50
rows?