Macro Help

Hello,

I have created a sheet which contains all the details abt the customer and feed back received from the clients and the sales team,

Each sheet is the data of each customer.
Sheet names will be "Customer 1, Customer 2, Customer 3...."
In the home page i have given the names of some customers and hyperlinked the names with the respective sheets,

There is a cell "M3" in each sheets, which displays the respective customer name in the home page.

Now i need to build a macro for the following.

When we run the macro, the "customer 1" sheet should be selected and the same should be copied and moved to the end nd the new sheet which is created will be named as "customer x" as per the order.

Then the macro should go and stop at the last blank cell in the home page and ask to input the customer name in the cell.

Once we enter the name, the cell should get hyperlinked to the newly created sheet.
and the Cell "M3" should display the newly added customer name.

Pls help me on this soon