We have multiple sheets with tasks. Each line on a sheet represents a task. Each department has its own sheet. Columns for all departments are the same.
Need to pull data from the multiple department sheets onto one master sheet, then sort that one by date.
One issue is that some of the tasks have date ranges instead of just due dates.
Can it be done without hiring a programmer?
