Hi,

I find your workbook extremely difficult to understand. In particular I'm struggling to understand the concept of adding data to one table and then when some event is triggered copy (or move it) to another table.

Conceptually I can see no reason why you couldn't use a single table to capture data, and then use standard filtering functionality to analyse or present/report against it. Maybe even using a pivot table.

If you can start from basic principles (don't attempt to explain what your current system does) and explain your data and what you want to get from it then perhaps someone may be able to help.