You can create view something like this
CREATE VIEW ViewName
AS
SELECT ColumnName FROM [Database1].[Database].dbo.TableName
UNION ALL
SELECT ColumnName [Database2].dbo.TableName
UNION ALL
SELECT ColumnName FROM [Database3].dbo.TableName
After that you can do your logic according to your need.