I have a workbook set up with hundreds of single row range names with the
columns showing January to December. Each row is a different Chemical.
What I need to do is have the chemicals listed on a different sheet with
columns showing various data. The formula needs to pull in the month being
questioned, then populate the relevant columns with the corresponding data
from the range name.

ie Salt may have range names for the following data by month.
Budget Price, Budget Volume, Actual Price, Actual Volume, Price Variance,
Volume Variance, (these are by row and months by columns).

On a different sheet I want salt on a row with 1 months data for categories
above to be displayed by column. If possible 1 variable cell to change the
month.

The rest of the workbook finds values by month because the sheets are
identical in their column discipline, but this is not the case on the front
summary.

Hope this is clear!