I have a Pivot table that is always changing when I update it. I want to create a manual table that says (ex. go find Arizona's sales # for October and then add xxxxxxx)

In the pivot table, Arizona would be on y-axis and the current month on x-axis. values are sales figure.
The pivot table is constantly moving forward though. Like I can only see the current month's number for each state.

I dont "GETPIVOTDATA" would work because it will always be locked to certain month. Should I use vLookup?