When using query, the data combined with a table style format.
I want to keep source excel file format e.g. cell color, cell and text format.
I am using query with the following steps. (excel 2016)
New query > from file > from folder > combine and edit.