I am trying to create a macro that will go through each row on a worksheet and move the data to another worksheet. Data in column A on each row should specify which worksheet the data is moved to. I want this data pasted to the end of each worksheet based on the data in column A.

For example, we have 3 stores listed in a workbook, each having its on sheet. Each sheet has a history of data and we want to automate moving daily numbers from the cover page of the workbook to the row below the last data entered for each sheet based on the data in column A.