Is there a way to create a Pivot Table that uses the information in another cell as part of its Range?

In other words, can I have a workbook, worksheet, or a cell array as the contents in a cell and use that information as part of the source range for a pivot table?

THANK YOU in advance,
Vince