Dashboard - Excel sheet with macros data need to show in Dashboard

1) Excel file with 3 sheets.

2) Excel uses macros and data from sheet1 and sheet2 places output in sheet3.

3) On Dashboard some single values components will be used for analysis and that

Interactive data from single value components need to be taken out of dashboard.

4) Need to do calculations with sheet3 data. (single value components data and sheets3 data)

1. i.e No calculation within the Dashboard Excel sheet should be done.



Final calculated/Analyzed data need to be shown on Dashboard and able to export the data to Excel after Analysis.

with no manual loading of data from import or export option in dashboard .