Copy and insert cell info macro help

[JackR]

I have over 50 sheets in my workbook; each sheet contains a recipe, with new
ones being
Added all the time by users, each sheet is identical, only the data is
different.
What I need is to have a master list, with the name of each recipe, and also
certain cell information, i.e. recipe name, recipe cost, recipe yield etc.

Since recipes are added and updated all time, I would like to add a button
that would trigger the macro to go out search for the information and add it
to the master list, always adding after the last row, Once that is done I
want to be able to sort the list by a certain heading (recipe name).

Also need to know what happens if a sheet is deleted and the master is
updated, will it just remove the information from the master list?

The final look of the sheet needs to be like this

NAME COST YIELD
Lasagna $4.50 25
Pizza $3.50 8
Spaghetti 5.00 3

Hopefully someone can figure out how I can do this, your help would be
greatly appreciated.

 

[Crowbar via OfficeKB.com]

It would be a lengthly procedure to do but you can email me your list at
(e-mail address removed), I'll put a bit of code init and send it back, that would
be a start !

 

[JackR]

I will send you a sample so you can visulize what I am trying to do. The
attached workbook will be name Sample Recipes.

Thank you