I need a vba code developer

Job ID: 34771710

Budget: ₹1,500 – ₹12,500 INR

I require to simply copy entire data of 5 sheets to new workbook and rename the workbook as per a cell reference, post which to save to a location as per a cell location specified