How to Insert Multiple Values into Multiple Tables in a Single Statement?

Find all tables containing column with specified name in SQL Server

Is it possible to query for table names which contain columns being xyz