I don't know too much about what we import from Mexico and Canada, other than I know we have factories in Mexico.
As far as jobs, those got offshored originally starting in the 70's because companies wanted cheaper stuff, i.e. lower wages. The notion to bring the jobs back here is great, but I don't think companies will want to pay higher wages (if that does happen that's awesome but I'm pessimistic), and they really don't have a choice with housing costs the way they are now (also pessimistic), so I see the pendulum swining back eventually. Maybe legal immigration will become easier and deregulated. Maybe enterprises needing cheap labor will become more directly involved in the process.