Downloading or Extracting excel files, Downloading file or Extracting data from Excel file stored in other we Options

[Rayx]

Hi,

I have equivalent to "No knowledge" in HTML or Java script, hence taken shelter here to find a solution to the problem confronting for last 9 months. I desperately need your help. The problem discussed below:

Problem:
Everyday morning I download 32 fresh excel files from an intranet site, then open each file (workbooks) and copy data from 2 different sheets in each excel file (workbooks) to make a master excel file. This manual process takes hours to complete, afterwards I prepare dashboard with the same data in excel, which makes the excel file heavier and slower to work.

Solution Needed:
I want to create a webpage which will solve all the above problems, mentioned in steps below:-
1. Download 32 excel file, selecting different options in 3 different the drop-downs (one is country lists, the 2nd is date and the 3rd is Job Received/Running/Job Done)
2. Extract data from each file and save in a 3 different excel sheets (received,running,done accordingly) in one workbook
3. In the webpage I need some buttons to show the count of works are done and received yesterday and count of jobs running till today and time since the job is running
4. Finally a graph to show the counts of received, done and running from last week till today

I will be obliged if my request is heard and extended a hand of help.

Thanks and regards.