I want to further automate my excel based schedule using macros. This main sheet should be able to collect relevant info from other excel schedules and templates, consolidate it and then perform search functions. Then afterwards, I wish to perform a gap analysis with this template by comparing demand and availability from the schedule. In other words, I want to use this as a planner as well.
Automated dashboards is a plus