Combining Data from several cells into a Title

Greetings-

I need help, and I don't even know if this can be done.

I need to generate a Concrete Mix Design Report, & I'm referencing several cells, to have that data appear throughout the report. This report will be fully generated & automated by entering data on multiple sheets in the file. Since, everything will reference other cell throughout the file, I wanted to see if I can generate a title, based on data.

An example of a title would be:

"3000psi, 5.00 Sack, 25% FA, AIR, WR, W/C Ratio: 0.48" whereas 3000, 5.00, 25%, & 0.48 is data in the file, & FA, AIR, & WR appear b/c YES was selected in certain drop-down menus.


Another example would be:

"3000psi, 5.00 Sack, W/C Ratio: 0.48" whereas ??% FA, AIR, & WR do not appear b/c NO was selected in certain drop-down menus.


Have I thoroughly confused you yet? I attached a file to help out.

I'm using Excel 2002 SP3 if that helps.


I really appreciate any info you can give me on this matter. Thank you in advance!!!


-Bryan

Oh my, that is EXACTLY what I was needing! Thank you so much!!