Formula to Filter Rows Into New Database on New Worksheet Based on Column Value

I was curious if there was a formula for this, as I typically prefer formulas to macros (not everyone who will be using this can be trusted to hit a button before pulling data).

I have a large database that is constantly being updated ... sometimes with copy/pastes or deletes of thousands at a time. I'm wanting to break down the database into smaller ones, doing so by segmenting rows according to a shared column value, and have them post in a new database on a new worksheet in the same workbook. I don't need them removed from the first page, but I can't have blank rows included in the new sheets.

Here, I'll give an example in hope of being clear:

Gen Code	Ref ID	Hits	Sales	Rev.
DCH	04823	21	3	90
DCV	04117	54	12	452
DCH	03991	37	9	242
DCR	04231	18	4	132
DCV	04441	5	0	0
DCV	03872	72	17	553
DCR	04086	31	2	56
DCH	04004	42	12	347
DCN	03641	112	37	1009

What I'm trying to do is to have all the "DCH" Gen Codes listed in Sheet2, all the "DCR" Gen Codes in Sheet3, all the "DCV" Gen Codes in Sheet4, and "DCN" in Sheet5.

Is this AT ALL possible with formulas on those sheets?