Can some one help me change the data source on the Named Range for the Pivot
Table.

For example - the named range refers to Sheet 1. Change the named range to
refer to Sheet 2.

Thanks.