Copy And Paste From One Tab To Other Tabs Based On Tab Name

Hi,

I'm stuck on a bit of VBA and I've been told you guys are the best so lets hope you can help me out.

(1) I have a workbook with a tab called Data on it, this list lots of organisations in col A (and other data up to col H).

(2) I also have different tabs in same workbook named after the individual organisations.
i.e. in point (1) above the list will contain all the data for Asda, Tesco Lidl etc and the individual tabs will be named Asda, Tesco, Lidl etc.

(3)What I'm trying to do is have a VBA macro button which when pressed, the data from the Data tab is copied and pasted into the relevant tabs
i.e. the data for Asda from the Data tab is copied into the Asda tab on row3, the data for Tesco is copied into the Tesco tab. etc etc.

(4)I would also like to leave the full data in the Data tab as well please.

Thanks in advance.

Thanks for the very quick prompt,

Is there a way to have it as a macro that runs after clicking a button please as I will be pasting data dumps in the Data sheet from sql to start with.

I want the users to only populate the tabs once they have made any late amendments to the Data sheet.

Also will the data paste on row 3 as I dont think the above is doing that.

Thanks again.

That is exactly what I needed, thank you.

Saved me a lot of time so really grateful.