Build Me an Excel Tool

I work for a global management consulting firm assisting a client through a re-org design. As part, we're seeking to develop an Excel-based tool that incorporates multiple data sources to rank employees based on their aptitude for a new role. The end user (oversees multiple stores) would use this tool to identify best-fit candidates within each store. For stores without a best-fit candidate, the end user would select from a list of eligible candidates not currently selected into a store. This list must automatically refresh once a candidate is selected to ensure the end user cannot place one candidate within multiple stores. An ideal tool would leverage VBA to create a streamlined, user-friendly interface with a back-end that can be easily updated with key inputs (project is confidential; as such, dummy data would be provided for the initial build - updating this data easily following tool hand-off is critical). This tool may need to be duplicated multiple times for various geographic regions - an automated solution is preferred.