>If your manufacturing employer consumes steel and that steel is now more expensive it means less of those jobs, not more

Then don't impose a tariff on steel, impose a tariff on consumer products. It's an instrument of economic policy, not a binary all-or-nothing choice.