And to refresh the data (in #10)

Excel 2013 => data = refresh

If you want explaination on the pivot table, just ask.