Replicate columns onto separate tab in same workbook

I have a spreadsheet with 46 columns with essential data in.

In order to make visualisation of important data easier for a client, to avoid them having to interrogate multiple columns, I need to replicate (and automatically update) half a dozen or so of the most important and relevant columns onto a separate tab but the data in the columns needs to update as the data in the main spreadsheet is updated.......

Is this possible? TIA

Read the yellow banner at the top of this page and attach a sample file.

My first step would be to convert the range of data on sheet 1 into a table (Table1).
One option would be to produce a pivot table as modeled on sheet 2, that displays the six columns. When new data is added to the table then selecting a cell in the pivot table and choosing refresh from the pivot table tools tab, analyze subtab, will display the new data.
I have also included a formula option on sheet 3 using: =IFERROR(INDEX(Table1[[ACAPS Job Reference Number]:[TP Nš]],ROWS($A$1:$A1),MATCH(A$1,Table1[[#Headers],[ACAPS Job Reference Number]:[TP Nš]],0)),"")
For the formula option you would need to copy the formula down the sheet for at least as many rows as in the data that is being retrieved from sheet 1. You could anticipate the maximum number of rows that will be filled on sheet 1 and copy the formula at least that far down on sheet 3.
Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.