Excel VBA

Developing a system (excel 2007) containing 6 Dynamic pivot tables, all sharing the same data source. The data source grows by rows. the data source extracts some of its records from an external excel file, some looked up from a \'Dynamic table\' (growing by rows) within the system and some calculated (basic arithmatics). the dynamic table within the system that data source looks up for values is only accessed through macros for adding/deleting/editing records.