Macro to copy specific entries and adjust value based on a table

It was only a coincidence that it sorted by Name as your workbook was sorted. I added an extra sub to sort however I was not sure which column was Store - I assumed column C was store so you will need to adjust sort macro as required. I added code to clear the output from Export sheet prior to data being copied across as well. See attached workbook V2.