Could someone point me in the right direction or give me a reference on
automating pivot table creation.

I have a pivot table created but the information it is based on changes
on a daily basis. What I had done was set up a macro that pulls the
new list data into my workbook and replaces the data that the pivot
table is based on, then refreshes the table. That way I don't have
to rebuild the table each time I have to update the list. The problem
is that the dropdowns on the pivot table still reflect the old data
values along with the new ones.

Is it possible to get around this and reset the table completely
without having to recreate the table? Or is there a way to automate the
creation of the table?

Thanks
Steve