Doing some charity work, now need some help in sorting data I collected

Multi-column and row data set.
Looking to copy entire line of data (or range within row) to a new table based on searching one column to match a search criteria. For example: search col “C” for #1, copy “all” rows of data into a table that has a title “Volunteers with 1 Family” . Another return table set up for #2?etc.

Working with excel in a Mac = No VBA

Any Hope in this other then putting a lookup formula into every cell of every result table?

Would use the same process on another data table of Clients to sort into other output tables that would depend on a string .