values from one sheet to the next.

[derailed77]

I have on "Sheet 1" a list of information in 4 rows. On all "sheets" after that I will have tables set up that will have a drop down selection in column "B" there will be between 10 to 50 rows depending on the application.

what I am trying to accomplish is to have to formulas in "Sheet 1" populate the other sheets but only but have the values be dictated by the information input in Sheet 2 Column J.

I have attached what I have so far.