I need some help with a macro to use on a worksheet that would be able to search and grab cell data from another work sheet and enter it in the main worksheet.

I have 3 worksheets: Input Log, Dispense Log, and Formulary Table. The Formulary Table contains a list of UPC's (Column A) and the corresponding Product Name (Column B), Brand (Column C), and Package Size (Column D).

What I am looking for is an ability to hotkey a window under the Input Log worksheet that would prompt for the UPC, a quantity, and the employees Initials and then would enter those fields in the respective columns in the Input Log worksheet. [UPC in Column A, Quantity in Column E, and Initials in Column G]. I then need the macro to take the UPC entered in Column A in the Input worksheet and search the Formulary Table for a match. Then take the data from Columns B, C, and D in that same row and populate the cells in Columns B, C, and D in the corresponding UPC row in the Input worksheet.

Is there a way to have the data automatically be entered in the next open row below the current data set? I'm not very good at writing Macros in Excel so any help would greatly be appreciated! Thanks!