As far as I know Data tables won't work over multile workbooks.

can you upload a small sample file? With out seeing the other sheet and how it flows I personanlly find it hard to vissulalize. It would be easier to see what the final outcome needs to be and how the formulas work together.