Order Form (worksheet) populated sequentially with items selected from other worksheets

Hi All-

Completely new to this forum, but a fairly long-time Excel user.

I have a workbook with a series of worksheets with stock lists and pricing that I would like a user to be able to select items on (say, with a checkbox) that would then automatically populate a separate master Order Form sheet. The Order Form sheet is currently blank, with headers, and I would like only those items selected on the various stock sheets to be displayed on the Order Form.

If this isn't clear, I can generate a sample and post.

Thanks

Yes, post a sample workbook - the FAQ describes how.

Pete

Attached sample. Sorry for the delay, had some work server firewall issues.

I've amended your file with the necessary formulae - the attachment also includes many notes in blue.

Click or unclick Add to Order to see an immediate change in the Orders sheet.

I was thinking that you might need to include a Quantity column, i.e. I want 6 of this particular fitting.

Hope this helps.

Pete

That was it perfectly!
Thanks!