Collecting input from another tab and reflecting it in base tab and formulating define

Hi,

Am having sheet 1, in which there are sets of parameters type A to Type N, in column B I had used “defined name for the value” in column C.
This is my input sheet which I forward to 2 different sources. In response the send data in diff format which I had shown scattered in next tabs.
I required when I select source 1 in “A2”, data to compile and formulated, for selected source.
I think code should ask me question “Select Value A?...till value N? if the required cell is blank it should be “NA”, & those value to be should appear in sheet 1.
Secondly most of the time the parameter is sheet 1, matches with the parameters next tab, can code search for parameter and select cell right to it taking my confirmation, (if selected value is ok), if not then select value.

Thanking you verymuch.

Okay, I try with some example.

I want to calculate area & volume based on the value given by any supplier (source).
Both Sources provide me data which i copy in next sheet.

The parameter given by source in scattered somewhere in sheet, which i need to find out, and choose for calculation in sheet 1.

As i required only certain parameter in sheet 1, such as radius and length, if i choose source 1 in "B2" (in sheet 1). Radius and length to be taken from source 1 sheet "E5, E6" cell, if i choose source 2 in "B2" (in sheet 1), radius and length to be taken from source 2 sheet, "F6, F8".

Second part cad code asks to select parameter, by asking me select radius, as i need this to do manually.

Third part can code automatically search and select radius value, from source 1, as i had selected source 1 in B2 in sheet 1.

Thanks for you valuable time to understand and resolve issue