Automatically copy from one page to excel

Hello,
I want to copy information from one sheet to another regarding the categories.
For example if I have airline company name, aircraft type, groundhandling company etc., I want to categorize them according to 1.aircraft types 2. groundhandling company in two different sheets to make soma analysis. Can you help me to find out how I can do this work?
Thank you in advance!