Combine two sheets with same format, different data and sort by sheet

Hi,

I have a problem that I have been trying to solve for the longest time but just cant figure out how to. I will just draw up a mock of the sheets and the desired output below and hopefully someone can help me out.

Sheet 1:


Branch 1

Model Order Allocation

X A D
Y B E
Z C F



Sheet 2:


Branch 2

Model Order Allocation

X G J
Y H K
Z I L



Output:


Model Order Allocation

[-] X
Branch 1 A D
Branch 2 G J

[-] Y
Branch 1 B E
Branch 2 H K

[-] Z
Branch 1 C F
Branch 2 I L



If someone can help me out with this you would be making my life a lot easier and I would be very grateful.

Hello Gizmotek, welcome to the forum. How about posting a workbook with sample data and desired output. Looking at the sample above its difficult to make out which colomn is text and which one is number. Best Regards/VKS

Looking at your example it looks like you just need to do a V look-up to get all of the information for each in one spreadsheet.

Post a real example with how your spreadsheet is structured and how you would like to see your results.