Find Cell Value in Workbook; Paste Cell Range When Found

[bbarber71389]

Hello. I have built a workbook that acts as an inventory search engine. My inventory data is inputted in various tables throughout many sheets, and upon executing the Refresh All command, will export their data back into a compiled table on one sheet - titled 'Codex'. This compiled table contains all the data that is referenced in my search engine sheet - titled 'Search Engine', which will populate a list of matching text once the desired search input is entered. From here, a column titled "Shelf Quantity" will remain editable to the user in order to update stock quantity of the line item.

What I hope to build is a macro that will copy this "Shelf Quantity" value after edits are complete, find the inventory item at it's source table in one of the many sheets in the workbook using the "Unique Identifier" cell value, and paste this "Shelf Quantity" value in the appropriate cell on the table. Once this is complete, the macro will move to the next row down in the 'Search Engine' sheet, and repeat the process, until the macro sees a blank value in "Unique Identifier", indicating that all edits have been consolidated, ending the macro.

I am having very little luck developing the code needed to perform this function. Any takers?