Sorting and copying columns (Forms)

Hi all, hope you can help me..

I have a table with a defined number of columns, but where the rows will continually be increasing as new data is added.

I want to create some forms where the user can choose which columns from the total list they wish to create a table from and which to sort by - ideally i want them to be able to select this from dropdowns or radio buttons.

Then basically i want a copy of the original table to be produced on a separate tab only using the columns selected and sorted by the columns selected by the user.

So to clarify, if the full table has the columns, age, name, date i want the user to be able to say 'i want a new table creating showing me just the columns age and date, sorted by date' and for this new table to go to a new worksheet with only the columns included they selected, leaving the original table in its original place unchanged.

Any takers?! I'd be eternally grateful! I attach a hypothetical example so someone kind enough might add the functionality and i can then replicate on the proper version..