Google Sheet : Import From Multiple sheet into 1 sheet with keep format

it seems to be a simple matter of knowing which column is coming from which sheet, then in the first cell typing "=", then click on the first cell of the source column, then hit Enter... then drag down. And do the same for all other columns.

or if you are tying to copy a range, then select the range and copy and paste it, all formulas will be preserved. im guessing that is how you have already done it so im not sure what you are trying to do differently.

Maybe something like this;

Please Login or Register  to view this content.

Or;

Please Login or Register  to view this content.