Use Macros to copy worksheet and rename using a list of names [Solved/Closed]

Registration date
Saturday October 7, 2017
Last seen
October 7, 2017
Hi all,
I'm an excel novice and hoping for help.

I need to write a macro to
1. Copy worksheet "Alstromeria" and
2. Rename worksheet to the names in a worksheet 'List'. The list of names is from A1-A70.
3. Copy column data from "Master" worksheet.
See more