t-sql insert - select - with parameters

I have a 4 tables. One of the tables we are going to be inserting data into (Table A). Table A is going to receive misc data from Table B, C, D and also some unknown variable parameter data.I have a 4 tables. One of the tables we are goi