Creating multiple sheets based on data from main sheet

[asddsaasddas]

I have a huge chunk of data retrieved from the system. Column A to Z is populated with with various headers ranging from date, Id, projects etc. The rows of data are not consistent and it ranges from 100-200 rows. This data is then placed in a template and it get manipulated with already existing macros to filter out the number of staff in each of the 10 departments. To put you into perspective, the existing macro helps sort the amount of staff in each department for that particular raw data and display it at the side. So now, we know how many rows of data belongs in each department. Thus, relating back to my question. I want to be able to create a new sheet for each department with the department's name as long as it appeared in the raw data. For instance, only 8 out of the 10 department appeared in this particular set of raw data, thus, there should be 8 new sheets with the department name as the sheet name. Now, for each individual sheet, I want to only include some headings that might or might not be found in the raw data. E.g. I want 2 headers "departments" and "projects" from the raw data sheet to be displayed but i also want another header "officer in charge" from a completely different excel sheet (not retrieved from the raw data excel sheet).


Any help is appreciated. Thanks in advance.