Perhaps it would be easier for you to copy your numbers to Excel and then paste them back into your sheet. QUERYSHEET will NOT work between books but only between sheets in the same book and only the top left cell of a named range is copied.

=QUERYSHEET("Twelve Month Income","D9")

would copy the value from cell D9 of sheet "Twelve Month Income" to the cell of the formula.

You would need to repeat the formula adjusting the "D9" value as appropriate.

None of this should be necessary for you to get the "formatting" you require as each sheet maintains it own page formatting.