Filling out a production Schedule

[Cdworks]

I want to create a schedule sheet.

That pulls from multiple worksheets.

It will have a worksheet for lets say,

windows
Screens
Glass
Accessories

under each worksheet it will have information such as quantity
PO#,WO#,backordered etc.

I want it to pull from each worksheet to fill out the specific section on the schedule based on a Delivery date.

I dont know if there is a function i could use or if i would need to create a macro. It has been a few years since i have done any programming .

Any advice would be appreciated!

Thanks In Advance
--CDWorks