I have:
******A**************B**********C**************D**********E**************F******
******ItemA**********Units********Price**********Net Total*****Sub total********Total*****
******ItemB**********120********$784************1000*******X**************Z****
******ItemC**********100*******$897************1200********X************Z*****
******ItemD*********756*******$200*************451*********X************Z*****
***Cardboard Box******45********$125************132.02*******X***********Z****
I want the macro to find through a list of items (ItemA, ItemB, ItemC, ItemD, ItemE, ItemF...) if the entry is found, then copy from that entry's row, column A, B, C and D and paste it to the worksheet with the same name (ItemA, ItemB...) in the next available row with the time stamp at the end column E of that worksheet.