I have a very large spreadsheet that has approximately 41 columns and 3000
rows. A new sheet is started every month.

Is there a way that I can have information from the main sheet transfer to
another sheet if column E is equal to a certain name?

Example - every patient that went home I want to transfer on a separate
sheet, every patient that was admitted I want to transfer on a separate
sheet.

Thanks for any help.