I've got a worksheet with 100+ pivot tables that should reference a total of 4 caches.

There are 4 groups of tables that will share caches and they are organized by rows. I need a macro that will look at the tables in a given group of rows and assign them all to the same cache. Then, it should assign all the tables contained in the next set of rows to the next cache. Also, there are multiple pivot tables within each row -- for example, row A has a total of three pivot tables as you move across the columns.

For example, pivot tables abc - xyz are located within rows 1:200 and all should use cache1 as their data source. Then, tables def - uvw are located in rows 201:400 and should all use cache2 as their data source. Etc...

Thanks for the help!