Is it possible to Cascade Data Tables?

I have a complicated sheet with a Data Table, call it DTA.

DTA has a number of rows for which I calculate an AVERAGE of a particular column.

There are many cells whose values effect DTA output - not just the one I chose for the DT input.

Now I want vary one of these other cells and see how it effects AVERAGE.

So I build DTB with an input of this new varied cell and an output of the varied AVERAGE.

Now when DTB populates the rows by varying this new varied cell, DTA must recalculate to get the proper AVERAGE for the DTB row.

That is not happening.

QUESTION: Can you define a DTB where for each row, another DTA must recalculate to populate?

OR: Is it possible to Cascade Data Tables?

I've never written a macro which interacts with the sheet - mine have an input from the sheet, do their thing, then place an output on the sheet.

If I write to a cell, does the sheet recalculate before the next MACRO statement is processed? (This would be necessary since I need the recalculated cells to copy to the new table I'm building.)

ALSO, I'm trying to think of any tricks that still might allow Table B to use Table A results.

THANKS for the code. It was the Application.Calculate that I was unaware of but suspected one existed.

Would set up MACRO to run on OPEN and also upon any RECALCULATION.

I know how to do on OPEN, but how to run on RECALC?