Could you address ALL these please:
  1. I see the formulae refer to cells on the same sheet. Would it not be possible to get this data from the Consolidated sheet?
  2. Are you expecting plain values in each output table in the end, or are you happy for formulae to remain?
  3. When an update of new data comes in, will old values remain the same? I ask this last because a complete refresh/recreation would be much easier and more robust than adding new data below old data.