Develop an Excel macro capable of extracting data from multi-tab spreadsheet

Develop an Excel macro/program capable of extracting data from a team timesheet. The team timesheet consists of : - A personnel tab containing the names and details of team members (25 maximum; in rows) - Six weekly tabs containing a list of 500 potential activities (in rows) and 25 groups of columns (each 5 columns wide – one per day of the week per team member). When a team member performs a given activity on a given day, they input the % of their daily time spent on the activity. We are looking for someone to develop an Excel macro/program (compatible with Excel 2013) which performs the following functionality : - Accepts a file name corresponding to an Excel team timesheet file - Opens the file - Processes all six weekly tabs - For each weekly tab : identifies all non-zero cells (i.e. an activity on which a team member has spent time on a given day) and creates an output line containing : team member details from the personnel tab; activity details; the % value that indicates the time spent by the individual. - Produces a CSV file with all the output lines. We will provide : - The desired format of the output CSV file - A sample team timesheet file with full data