VBA Update Pivot Chart based on lists - data set in another sheet

I hope someone can help.

Tab: Dashboard holds the 2 lists.
Tab : Custom Filter holds a data set which gets filtered based on what selections are done via Dashboard

Based on the selection from Dashboard, the data set changes in Custom Filter.
A Pivot Table in Custom Filter was created to reference this change. (This is so that I do not have to make various Pivot Tables for every selection). A Pivot Chart was created and placed in Dashboard.

As soon as a change in either of the lists in Dashboard is done and the data set in Custom Filter has been automatically changed. I want the Pivot Table and Chart to be refreshed.

Please Login or Register  to view this content.

I have the following code which holds no errors but the Pivot Table in Custom Filter is not refreshing meaning the Pivot Chart in Dashboard is not refreshing.

Thoughts?

UPDATE:

I got the following code to work:

Please Login or Register  to view this content.

However, I need to implement another line which says something like

Please Login or Register  to view this content.

But I get an error...

UPDATE:

Following code works for me:

Please Login or Register  to view this content.