linking cell value to specific worksheet in the same workbook

[lester]

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