book due records for sorting and placing in text (Library related problem)

I have a excel file (attached ) consists of 3 sheets. The first sheet is the input sheet consists of set of records related to the list of faculty who are due to return the books. This is a big list. I given for 4 members. In the second sheet named ' Sorted' the list was sorted with faculty name / department. i.e., all records related to one faculty came in sequence.third sheet named ' final output' displays a fixed text followed by set of books due by a single faculty. Similarly for all faculty members, the same text has to be displayed followed by the records related to a particular faculty. The input consists of 4 faculty members. So in the final one 4 outputs will be generated with same text (i.e., company name, librarby, to, date, text of 2 lines followed by records related to particular faculty and finally signature of librarian).

Please help for a macro to get the output as 3rd sheet. I have lot of data to generate output for nearly 300 faculty members. Kindly help me.

I have to give a printout for each one separately. that's why i requested sir