How to create an executive summary of a text-based data list?

Hi!
I have one worksheet filled with a text-based multiple-column list. On a
separate worksheet, I am trying to insert just a few of the columns to
function as an executive summary of the big list. How can that be done in a
way that data is automatically updated in the exceutive summary worksheet
whilst I add stuff to the big list?

Thanks in advance!

Best regards,
Magnus.