Grouping and Multi sheet Reporting (with joining of different tables)

[EricaMN]

Hi there,

I am having some trouble with outputting reports. I am experiencing two different issues:

I have reports which I need to group by departments but also have multiple sheets which show tables by level.

I am able to get my tables grouped into separate workbooks by department but am not able to get the levels to appear on different sheets.

I have two different workflows where I’ve attempted this:

1.  below where I separated out the tables by the level and then tried to join and output into multiplesheets

2. where I have kept all levels into the tables and am again only finding success in grouping outputs by department, but not creating separate sheets for level.

I am having a similar-ish issue where I can output reports grouping workbooks by department  based on level and when I join with similar reports to the above it will only join the one sheet but no more. Example attached. Sheet 3 is the layout of the table pictured in the workflow.

Thank you, any help appreciated!