My very first post! I need help with a macro in which I am trying to extract data from multiple sheets into one sheet (MainList). The final result I'm looking for (in rows) is:

Product Name ------- Date-------- Invoice #--------Customer----------Quantity

For the part that I'm assuming is easy - The Date is in C87 on all sheets, the Invoice # is in C84 on all sheets and the Customer is in B4 on all sheets.

Now the difficult part (at least for me) - The product name is in Column A on all sheets, anywhere from rows 106 thru 119 and the corresponding quantity is in Column E of the previously mentioned rows.

One final kicker, the quantity in Column E is based on a formula, so I'm looking to obtain just the value.

Thank you in advance for any help anyone out there can offer! Thank you!!!