If cell A3 is part of a pivot table, is it possible to
reference the table without knowing the name or index?

If not, how do I obtain the name or index of a table if I
only know it's location on a sheet?

I can set the name for a table:
ActiveSheet.PivotTables("PivotTable2").Name
= "MyPivotTable"

But I don't know or have control over the existing name
(in this case, PivotTable2).

It appears that the default name of the table is a
sequential number based on the number of tables created in
the same Excel session.

Thanks in advance for any assistance.