Some thing like this will work:
EXECUTE master.sys.sp_MSforeachdb 'use ?; select ''?'' dbname, name from sys.tables where name like ''%X%'''
Replace 'X' with your tablename. If you just want the whole list of tables with their database names then remove the where clause.