Good afternoon - I need some assistance since I'm stumped on this issue. I have a workbook that contains 6 tabs ( sheets) and I need to copy/paste them into new workbook. The issue that I'm having is that each of those sheets has multiple pivot tables in each one and I need those copied and pasted with only the values and the pt borders ( To look like a PT but with no PT capabilities). Right now its just pasting without the PT structure, and only values. Can someone guide me through this? I'm fairly new to VBA and any help will be gladly appreciated.

Also can anyone recommend a good book to learn VBA or website? Thanks again