Show tab from a different excel workbook

Hi, I am trying to show an entire tab on a new spreadsheet (2) including all formatting, spaces, conditional formats etc from a source spreadsheet (1)

I have tried various ways and the closest seems to be: Data - Get data - From file - Excel workbook - Find source file - Choose tab I want.

However when it goes into spreadsheet 2 I lose all of the formatting, spacing etc. Any ideas how to reflect it exactly as it shows in spreadsheet 1?