try to create stored procedure,
1. first you need to search tables in the databases with matching name,for example
sp_MSforeachdb 'SELECT "?" AS DB, * FROM [?].sys.tables WHERE name like ''Students'''
find you the databases where Students contains. refer
Find a Table on a SQL Server across all Databases[
^]
2. Now you need to build union sql statement based on above database and table values in your stored procedure. for example if you have BR_1, BR_2, your sql string will be
SELECT * FROM BR_1.dbo.Students
union
SELECT * FROM BR_2.dbo.Students
3. finally execute the dynamically created sql statement and fetch the data