Help Removing Columns and adding a Refresh Button

Need help removing columns that are not necessary in WorkSheet2.

The information needed should look like this:

PartNumber / Offset /.../Gain1/.../TCZ2

13 Columns all together on WS2.

No Need for SN and Status.

WS2 takes all the data from WS1 and takes each individual PN and provides the average per PN.

As an added feature, I would like to create an "Import Data" Button from a .csv file in WS2.
Once the button is pushed, all the macros will activate. Which will import data, then sort said added data and provide an average on WS2 per PN.

If anything is not clear, please let me know and I will do my best to explain it further.