Need some programming in excel

Iffiz Posts 1 Registration date Friday February 24, 2017 Status Member Last seen February 24, 2017 - Feb 24, 2017 at 06:22 PM
Hello Sir,
I am A basic user & new to excel & coding. I will explain what I am looking for , than you can let me know weather it's possible or not.
For sales & marketing purposes, we have to generate data from mobile numbers & then try it with other prefixes, like I will put a number in one row & make 100 multiples of it in sequence manually than by using concatenate command I will merge it with other available mobile prefixes , on sheet 2 the result will come , with every prefix. What I want is that the result which comes on sheet 2 automatically becomes a new workbook and that should contain sheet 2 exact result in its sheet 1. Is it possible in excel that it generates a new excel work book with the result of sheet 2 of my working sheet to its sheet 1 & the sheet gets saved by the name of first value Available in sheet 2.

Thanking you in advance , it will be great if this is possible .