I meant 'Define' as in "assign a meaning to" - design, decide and create the structure of your workbook. This might be as simple as renaming the first sheet "SOURCE" and the other one "SUB1"
When you open a new workbook you have 3 sheets created by default, you can copy, delete, or rename these sheets or create additional sheets from a menu found by right-clicking on the sheet name.
How to i link the sheets to the original source page and the data in it's variable cells to each different sheet?
I'm not completely clear what you are trying to do when you speak about "variable cells" but if, for example, you set up the workbook with 2 sheets, one defined as SOURCE and one defined as SUB1 then the contents in cells on the SOURCE sheet can be duplicated in cells on the SUB1 sheet by using the = function. Suppose you have data in cell A1 of SOURCE and you want that data in cell C5 of SUB1 then you open SUB1, highlight C5 and press = on the keyboard. This allows you to click on another cell and press enter. C5 will then = the contents of the cell you selected. The selected cell can be on another sheet
or even on another workbook (although that is gets difficult to manage).
Continuing with the example - if you clicked on the SOURCE sheet and then on A1 and pressed enter you will return to the SUB1 sheet. Now you will find if you highlight C5 its formula (shown in the Formula toolbar) will be "=SOURCE!A1". From now on whatever you enter on the SOURCE sheet at A1 will also appear in the SUB1 sheet at C5.
If you set up your SUB1 sheet the way you want all your subsidiary sheets to look then you can make a copy of SUB1 at the end of the workbook, which will appear as SUB1(1). Rename it SUB2. Copy again until you have all the subsidiary sheets you need. All the realtionships between SUB1 and SOURCE are copied so C5 of SUB2 will contain the contents of A1 on SOURCE as will C5 of SUB3 etc.
I hope that answers you question. Sometimes these things are difficult to explain in writing, even though they are simple to do in practice.
Edited by Rimmer, 08 June 2005 - 07:32 PM.