Automatic creation of summary and filling of data

[jsridhar]

I wish to know if this is possible:

1) Customer Orders flow in and Work Orders are allotted.
2) Each order has a different production schedule
3) When an order is recorded, it should automatically create the data in the Summary Sheet.

I attach a sample worksheet of what I wish to have. Can someone kindly tell me if such a thing is possible in Excel, please?

[Limor_OP]

For each order you have a seperate tab?
You want a new log in Summary every time a new tab is open? Dont think it is possible with regular formulas...

[Pete_UK]

You could do it with formulae, but there would need to be some regular relationship between the names of the order tabs (and, indeed, between the order numbers). It is unusual to have work orders numbered in the sequence 123, 234, 345, and so on, although you might have just chosen those for this example file.

If you have a lot of separate tabs for each work order, then it would become a bit cumbersome using formulae.

Hope this helps.

Pete