Thanks allenm! That pointed it at the right sheet.
Then the next line of code gave me an error.

"Unable to get the PivotTables property of the worksheet class"
Thats what the error says. Why might this happen?

Jeez! I found this one line of code and I think it does everything I need without having to go through anything else. I just bring in the new data and run that line of code and it works perfectly to update the pivot tables.

So one more thing, does anyone know how to make a worksheet to where it can't be deleted by the user?

Thanks,
Dave