I want to set up a event spread sheet in my work place that is very flexible, fairly clean and can be used by idiots.

Firstly I have a Worksheet that contains a list with all the personal data for the attendees. eg. First Name, Last Name, Company, Seat Number.

When we hold the events we produce a variety of different materials that require parts of this data filtered and sorted in different ways.

I would like to create a different worksheet for each of these variations that updates as I change the original data.

I can obviously do a Macro Script that will run an advanced filter when I want it but there are other issues... When I do the advanced filter how do I:

Clear the worksheet
delete the columns that are not necessary
sort the cells
create new columns that are merger of 2 or 3 cells

If somebody could through me a few resources for these things that would be great.