Extracting data from 2 or more columns into one column

[meemee]

Hi guys,
I have to extract data from various columns into one.
Eg. I have 3 tables

Table 1 (jan)
Id Name
1 Rupa
2 Erica
3 Tries

Table 2 (feb)
2 Misha
3 Stinky
4 Weee

Table 3 (March)
3 Siera
4 Maine

I have a table containing names and ids.
Now, Some names were updated in subsequent months.

at the end of 3 months i have to make a report. the op should be
id name
1 Rupa
2 Misha
3 Siera
4 maine

That is I want the names that were updated to show up and the ones which werent to remain same.
Is there a way to do it using a formula in excel or query in access. if yes how?
please reply as it is urgent.

 

[XOR LX]

Hi.

What tells us whether a given name was "updated" or not? I don't see a flag in another column to that effect, for example.

Regards