Can you use a list autogenerate the values section in an Excel pivot Table?

[CKara]

My data has accounts (I am an accountant) for the rows and the 12 months for the current and prior year in the columns. I used a list formula to get a list that changes with the listed month (Want the current and the previous 12 months plus some other items) for the statement. These items in the list are all listed in the PivotTable Fields list. Is it possible to have this updating list update the Values under the Value Area Section?