Please help me for the query of attached file.

Can anybody help me for the following queries ?

Please use the attached file for the data.

We have the data and the pivot table
If we add the data after the cell A10 to cell A2000 or more than 2000 and used the pivot table. Now my questions are below.

Q1 Can we expand the range of the pivot table excepting by the use of "Change data source" from option tab ?
Q2 If we have 1000 or more than 1000 pivot tables then what will be the answer ? Because we can't use "Change data source" for more than 1000 pivot tables.



Thanks.