Glad to be able to help.

Considering that you probably will add data to this database, you might
consider creating a dynamic named range for the data area and use that
named range in the pivot table so that you don't have to revisit the
pivot table wizard to redefine the size of the database.

If that is new to you, here's how to get started.

From the menus...Insert Name Define

Name it Pivot_data or whatever is meaningful to you
Instead of selecting the area, enter the formula:

=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),3)

Here's what those formula components mean:

Sheet1!$A$1 - Use this point as a starting reference
0,0 - start the range zero rows and columns from the starting
reference. (if you didn't want the labels it would be 1,0 but you need
the labels for the pivot table)
COUNTA(Sheet1!$A:$A) - height of the range which happens to be equal to
the number of rows with data in column A. If there might be some
blanks, then choose another column to count
3 - the width or number of columns in the table

Hope that helps.