Split data into multiple worksheet

Hello,

I am creating an excel database for the membership of the organizartion i work for. I first create a table that starts with the company name of all the members. My columns include data such as address, phone number, email etc.

Our organization wants to keep track of marketing information as well such as which company participated in specific events or donated for specific event. Therefore, my table will be really long. I was wondering if there was a possibility to split my table sections into multiple worksheet and keep every row linked together as if it was part of one big table. I also need to be able to add members or delete some without messing everything up.

I also need to be able to extract some data from those sheets even though the information is not on the same sheet. For example, i need to be able to ask excel to find all the members who participated in a specific event, the person to contact and their email.

Just some thoughts. Keeping all data in a standard "long" table in a single sheet is ok and far preferable rather than having to maintain a scatter across multiple sheets. Then you can use Filter for any extractions, and also use pivots to analyse etc on that long table.