I have the following ask at hand and would like some help tackling it
- I have excel files with performance metrics for each employee in a uniform template (the template is not a typical tabular format, it looks something like the attached)
- Each department employees are stored in a single folder (i.e. Folder Name: Department 1, has say 20 files corresponding to 20 employees)
- The employee excel files consists of multiple sheets and I need data from all sheets to be extracted.
- I want to create a workflow that goes through all folders and all files and extracts the required data points about each employee and puts all data in one single master sheet
- Output template should include all the fields in all the sheets of the excel files
I really appreciate your help
Thank youEmployee sheet.xlsx (13.0 KB)