extract data based on a criteria

Hi,
i need your help.
1. i have a spreadsheet with expense details of employees belonging to different cost centers.
2. Could you please help me extract the data into new worksheets automatically based on cost center numbers?

i am a novice - due apologies if this is too small an issue.
Thanks in advance
sk

You could use the data filter.

Sent from my ADR6325 using Tapatalk