Can I make a list that auto-updates from multiple sheets?

[alleneure]

I have a workbook for warranty claims that I control and I also track the progression of the claim to hold necessary parties responsible. I have the workbook separated into sheets for pending claims, a progression sheet, a completed claims sheet for every month, and a master that has all of the completed claim numbers for the year. In the progression sheet I have to input the clam number manually. Is there a function or method to automatically pull the claim numbers from the pending claims sheet and the completed sheet?

I have tried using the unique function but it does not go across multiple sheets. Hope I explained that well enough.

 

[Jeffrey Mahoney]

In the example below, I have a Pending table on one sheet and a completed table on another sheet

=UNIQUE(SORT(VSTACK(PendingTbl[Claim Number],CompletedTbl[Claim Num])))

 

[alleneure]

In the example below, I have a Pending table on one sheet and a completed table on another sheet

=UNIQUE(SORT(VSTACK(PendingTbl[Claim Number],CompletedTbl[Claim Num])))

VSTACK is perfect! Since all the claims have a different number I don't need unique really. I figured out a way to do it but was much more complicated than this. Thanks!

 

[Jeffrey Mahoney]

Glad I could simplify. Do you mind marking my post as the solution?