VENDOR MANAGEMENT DASHBOARD

Hello dear Freelancers, There are two identical spreadsheet(attached) with several tabs, the only main diff is that one is belong to week 41 and the other one is belong to week 42, .. as you can see each tab will contain the info that will feed the summary tab... once again each of these files only contain one week info as previously mentioned.... the idea of this project is to consolidate many spreadsheets into one dashboard that will allow me to choose or navigate using different filters such as weeks 1-52= one year . Month 1-12. Fiscal Year 17-19. Please I am open to ideas as to how we can design a database and dashboard that will allow me in no time to choose and pick different filters or data sets by adding info into a database in a weekly basics. So I can look the info I want into one dashboard. For example, as of now in order for me to look into week 41 or 42 I have to open each of the files separately instead of having one single file that will provide the consolidated info into one using the filters (week, month, and year) desired. NOTE: as you can see my current dashboard is the summary tab, I would wish to redesign the format of it so it can look or show more professionalism and user friendly. open for suggestions on which database I should be using nothing complicated but well done... ...