Combine and work with data from multiple worksheets in Excel 365.

[Voodoowho]

I'm working with Excel 365 on a windows machine in a Citrix environment.
I have multiple worksheets. Each one contains different information, except that all contain the column headers "Assigned Rep" and "Date Completed".
I'm thinking I would like to make a pivot table (or whatever works) which allows me to see the total of entries in the "Date Completed" column across all of the worksheets for each "Assigned Rep" and to be able to know from which project (worksheet) the data was derived. In other words, on which projects (worksheets) did a rep work in, on a particular date, and how many assignments were completed... the count coming from the number of "Date Completed" entries. I'm not an Excel guru or anything, so I need a solution without much, if any, programming. I hope I explained it well enough. Thanks in advance for any assistance!

 

[Voodoowho]

I see 20 views and no responses, so am wondering if I wasn't clear enough.

I have several people working on different projects.
Each worksheet represents a different project with different columns.
However, all worksheets have in common at least 2 columns labeled "Assigned Rep" and "Date Completed".
I want to use these columns of data to compare the total workload (count of 'Date Completed') per "Assigned Rep" across all projects.

Does anyone have any idea how I can do that without using a Macro or VBA. Macros are restricted in this environment. Thanks!