The challenge here was to have the required data flow smoothly from sheet to sheet, and of the various spreadsheets I tried, Excel 2007 produced the best results. The disadvantage here is that I've never been a fan of Excel and have limited experience using it.

First test - data flowed from sheet to sheet smoothly and correctly. Problem - some labels didn't. Solution - sheet to sheet transfer of labels in columns changed to formulas rather than a copy and paste of the labels themselves - success. Required going back to each sheet and modding the necessary columns. Hidden benefit - additional flexibility in labeling. Version is now 6.1.