Subset of data

I run a weekly report, using a filtered dump of data from a company database. The database is maintained by a utility department with a large user forum; in response to user forum requests, data fields are added frequently to the database – several times monthly, and can be inserted anywhere in the dataset. My report displays a static set of fields; the data in the fields changes often. I also need to be able to split the dataset up into several groups of data. The number of rows can vary week over week, as an item drops off – sometimes before its due date, so the due date is not a field that can be used to filter out. I’m looking for a formula(s) that would read the headers, extract only the fields that I need, and also extract the fields I need into several tabs based on one of the values. In the example below, the first table is a representation of the tab with this week’s full dataset; the second and third tables are the results I’m seeking to have extracted. Have a formula(s) that would accomplish this? Thank you. I had tried Filter, but Filter will return all the fields in the original dataset. How can I return only the fields I need (in the example, columns A, B, C and E, but exclude D? And keeping in mind that next week's data may have a new field inserted before Due Date, and I won't know that field's label or content until it appears).