Lookup a value from multiple lists

[cryh548]

We have four different departments of employees, which all have their own SharePoint list. 

Each week I need to run a report of the number of hours each employee worked by their employee #. How do I lookup that employee number on those four lists and bring back some information in another column? I've tried excel, flow, sharepoint and I'm stuck. Help! 

[#2]

If you are just needing a report that doesn't need printed, I would create a PowerApp to do it. Connect it to the data source, and use a collect() function to collect the hours worked by running a forall loop against the data sources (the 4 lists) based on the empID you enter in a text field. Then it will display what it collects into a gallery of the collected data.