VBA Macro to refresh PivotTable.

Currently I'm running a Query that stores all the information it gets out of it into a table called "Query" on the 'ValidationTool' page. I can edit the dates the query goes through, by editing cell C1 example (5/22/2015 or 5/29/2015). I have another table called "Rooster" that helps to analyses the data and is on the 'Department Rooster' page. Then I have a PivotTable called 'Analysis' which helps to summarize all the data from the "Rooster" table into neat information.

Yet what my main issues is I can't figure out how to use VBA to refresh the PivotTable every time I enter a new data and the new query results show up. Any help on this would be much appreciated.

I tried

 
Private Sub Worksheet_Change(ByVal Target As Range)
    Worksheets("ValidationTool").PivotTables("Analysis").RefreshTable
End Sub

And have received and error when attempting to change the information in cell C1 and the refreshing begins.
It is a Run-time error '1004': RefreshTable method of PivotTable Class failed

Thanks for you help. It didn't work, but I decided to just make a Refresh button that corresponds to a macro I recorded. For some reason every time I tried one of the above codes it ended up making my excel go crazy. Yet once again thanks for trying to help poor ol' me.