i need to create a link between two sheets that creates a nicely laid out
smaller data sheet that can be exported as an object for a word document.
the second sheet will be using information from a main spread sheet that
houses all of my cost prices and margins and is huge....

i plan on using it to save me time cutting and pasting the various items i
need to compile estimates for customers.

i tried to assosiate cells but the layout on the second 'export sheet' was
very inconsistant..... ans spread out - and everytime i added a new item on
my trade price list - i need a formula that can pull information from a
section of my choice when a '1' or similar is put in a cell indicating it
needs to move to the next sheet.


i think you get the proiblem so i will stop now

thanks all for your help.