Guess what?

I figured out how to get the Pivot Tables to auto-refresh by adding a couple lines of code..... right-click on the tab and added the code and now it refreshes! nice.

Okay, so one last time I would like to thank you for all your help and for educating me.

I am about to release the new spreadsheet on my co-worker and hopefully it works well for him.

Thanks so much!