Hi guys
I working on a Bookeeping spreadsheet.
I need a bit of help.
I have three sheets
"CustomerList" with CustomerID in A column like C1,C2,C3....
SuppliersList" SupplierID in A like S1,S2,S3...and
"ExpensesList" ExpenseID in A like E1,E2,E3....

I want data (IDs) from all three sheets and populate it in another Sheet
called TrialBalance..
like
Column A
C1
C2
C3
S1
S2
S3
E1
E2
E3

Any tips here please.. (doesn't have to be in order and no duplicates)

thanks
Thanks
Rachid