One Master file to create different-2 file according to master file & save to computer

i have one excel master data file & given 3 types of sheet in one file & i want to save data
to one folder in computer &

all sheets first row are same ( heading)
column A all sheets given dealer code (all files save by dealer code name)
all 3 sheets name same

i m searching coding & i am finding one coding &
macro run then all sheets create automatically but no file name, no save files & also no sheets name. if possible please help me



i want only all files save in computer desktop folder name "master data" & only given coding provide by u i can only copy paste then run macro automatically create files dealer code wise.

i m also attached herewith

Master data file
marco coding
& also attached folder after create sheets (i want result)

Regard's
Dinesh Kumar
Mobile No.-09711718877
INDIA