VBA Extract Information from Specific Worksheets, Dynamically, into a Master Sheet

Hello, I have around 30 worksheets in this workbook and around 16 of them are recipes. New worksheets will be added each time a new recipe gets added into the workbook. I need VBA to find each recipe and then extract cell A2 by copying and pasting into a worksheet called "Menu Organization" Cell C5, from there in needs to find recipe 2, paste into cell C6, recipe 3 paste into cell C7 and so on. I can get it to cycle through each worksheet and find recipes which have a trigger in cell B1. It then moves the information in Cell A2, but it does not go to the next row, it keeps copying over the existing cell C5. It needs to be dynamic based on when new recipes are added. Can someone help me figure out what I am missing?

Please Login or Register  to view this content.

It did not work, as there is something wrong with the copying and pasting. I need to keep working on that offset function.

Ok I should have loaded an example.

Each recipe name should pull into the master sheet.

Ok. That works perfectly!. I just need to figure out now how to first delete the information in those cells, because I need it to overwrite, not add on. If you click the macro twice it adds another set of rows below it. If you know how to fix that, that would be amazing. If not I'll continue to work on it. Thanks!

Alright. Thank you. We can mark this thread as now solved. For one, I feel this is a very important piece of code that is overlooked in most threads. Thank you for your help.