Hello All!

Is there a way to create a list using specific criteria from another worksheet? It's hard to explain what I'm trying to do, so here's an example:

I have one 'master' worksheet that lists all volunteers for a specific event in column one. Each volunteer worked in a specific department, which I have filled into columns B through Z, and noted the honorarium funds they received for their work. Each person volunteers for only one department, for example, so each line looks something like this:
One Row.JPG

At the bottom of this first page, I used a formula to calculate not only the total amount spent on honorariums for each of the separate departments (=SUM(B3:B241)), I have used a formula to count the number of cells in each column that are not blank (thus, how many volunteers each department has: =COUNTIF(B3:B241,"#")+COUNTA(B3:B241)). The bottom of the first spreadsheet looks like this:
Totals Main Spreadsheet.JPG

WHAT I'D LIKE TO DO:

I'd like to create a separate worksheet for each department, include these totals at the top, and then LIST ALL VOLUNTEERS for that specific department. I know I would have to create a list, and then reference the department's column and then somehow link the $ amount to the name, but I have NO idea how to do this!! The following is a list I created manually, so this is eventually how I want these separate departmental worksheets to look:
Departmental List.JPG

I hope this makes sense and I hope these screen shots are attaching correctly! Thank you to anyone who can assist me with this!!