I have a master spreadsheet "Master",
with a list (35 lines) of 15 products. e.g. Siemens, Motorola,Nokia (Some
products have more than one line).

I have have another workbook with 15 worksheets (one worksheet for each
product).

I need to write a macro which will copy the lines from the "Master" into
each of the worksheets, so that for example- the Motorola Lines are copied to
the worksheet caleed "Motorola"

Many thanks for your help