I have spreadsheets with data I need to be compiled into one main spreadsheet and then the data needs to be shown as different metrics on a dashboard.
Each spreadsheet is a separate job with an expense summary with three different tabs and there is information in each tab that will need to be extracted job reimbursed expenses, payroll, total expenses.
I have a current template of the summary page tab, but would like there to also be a dashboard to show current expense vs income (by job and total (able to separate by dates) and be able to show cost per job, etc.
There will also be additional metrics that I will provide that will need to be added.
I would prefer either there to be a macros or scripts written to automate the process once I can add a new excel sheet of data. Must be able to work with me on making this easy to change and easy to add more metrics.
Please show me that you are able to do this with a previous example of spreadsheet done. I will have additional jobs as such which will require help as well.