I know you've accepted an answer, but I thought I would answer your question about how to 'redraw a Pivot Table (PT) when the data changes'.
This is a common occurrence - rows are added and fields completed, but columns stay the same.
To update your PT go to the sheet with your PT on and single click in the data; now go to the top menu bar and click on the new OPTIONS link. There you will see a Change Data Source icon. Click on this and it will ask you to define your data source. It will revert to your previous choice, and in this screen you can now manually include/select the whole table again.
Go back to your PT sheet and your new data should be there.
Hope it helps.