DiverMarv, let me see if I understand you problem correctly
You have similar table in different databases
DB1 has table T1 with columns A(identity), B, C
DB2 has table T2 with columns D(identity), B, E
DB3 has table T3 with columns G(identity), B, F
You wish to store all the date of T1,T2 and...