create multi-column list from multiple sheets

create and combine lists.xlsx
Hello,
pls see attached file as an example. In sheet "input1" I have a list of country / city pairs (1 column for each). The same for sheet "input2" but this time the columns are separated and not in the same position. I am looking for a way to create a list of the UNIQUE pairs of country / city, i.e. eliminate duplicates.
Please note the following:
From time to time the length of each input list may not be the same
The actual file may be more complicated, i.e. more than 2 columns
The colors are just to help me explain.
Thank you

Please Login or Register  to view this content.

FWIW:

Please Login or Register  to view this content.

Thank you stnkynts.
It took me much more to understand how some of the things work than it took you to write it!
In addition, I learned some things that I did not know. Some I could not understand but time is on my side.
What's more important I was able to modify it and deal with more columns.
A small disadvantage I think is that when a cell in the first column is blank then I will miss the pair...but that's not important in my case (at least for now)
thanks again!

Thank you JOHN H. DAVIS!
Unfortunately I get an error towards the end with

Please Login or Register  to view this content.

What's the error?

It's a bug...it does not work...and when i check...the part I copied is highlited