hi

this is my first posting and i'm hoping maybe you could help me with a really simple question:

i created a workbook for a bus company that manages the spares, tyres, etc of each coach.
there are 3 different sheets for spares, tyres and service. each of these sheets contain a column that contains the number of the coach.
I want to create a seperate sheet for each coach which summarizes the data in the 3 sheets for that specific coach.
say, in the spares sheet, the number of coach #1 appears in the column for coach no. the data in some of the other columns (etc date; spares used ) should then be duplicated onto the sheet for coach #1 in the same workbook.

I'm not sure if its clear but if u could help me it would save me a lot of trouble.

thanks
lester