Merge two lists (which both have label and constituents) into one list maintain hierarchy

[alexmues]

I am new to the forum and this is my first post. I have been battling with Excel the past couple weeks with an issue. I have multiple lists (all merged into one spreadsheet) that I would like to be able to dynamically merge, depending on which two lists I select. Each list is described by the letter in the First column next to the dates specified (in this spreadsheet lists would be X, Y, Z, A, B, C, D...etc). What I am trying to accomplish is have some way that I can form one inclusive list (with both label & descriptor - columns A & B) depending on which two lists I select. For example, if I want to join "X" & "Y" into one list, while maintaining the group hierarchy, how would I do this? I'm hoping to be able to do it in such a way that I can enter the two List letters (in this case "X" & "Y") and have that list populate on a separate spreadsheet. The next step would then be to match the weight & return of X & Y to the label & descriptor for each time period. I'm assuming that this would go alongside the joined list, with X having the weight & return next to the list and then the same for Y. There will be plenty of instances where items in X do not exist in Y, and vice versa. I want these items to remain in the consolidated list, but just show "0" for ones where they do not have a corresponding instance. I have attached the sample spreadsheet I am working with, and would appreciate any guidance on how to complete this. Is it better to create a list through name manager for each list that is on the spreadsheet? Would it be better to do each dataset on a different tab?

Thank you!