Using the “IF” Function in Excel

I’ve created a spreadsheet that is organized by Last Name. This spreadsheet also specifies the type of loan this person has. What I want to accomplish (I think) is to use the “If” function so that IF the person has 1 type of loan they will be pulled into a sheet specifically for that type of loan. If a person has another type of loan they will be pulled into another sheet for that type of loan and so on. I don’t want to just sort by loan type because I need final reports with all loans alphabetically and by each loan type. Does anyone know if this is possible and how to do it?