Saving a file taken from cells in a workbook and asking where to save it and in what format

[K0st4din]

Hello, everyone,
I found this macro and modified it a bit to suit my needs.
It takes what is written from specific cells and saves it.
However, it clearly needs something more added, because I'm running into the following problems:
When it saves it, taking the text from the specific cells makes it merged: IvanIvanov12024, I don't know how to give it the spaces in the macro to make it Ivan Ivanov 1 2024.
The other thing I don't know how to do is that in this workbook I have more worksheets, and this macro saves, just one, I want to save the whole workbook.
And the last one is I don't know how to make the SaveAS dialog box - so that I can specify where to save it (or a second option, ask me where again, but if possible it will self-navigate to the location where the file itself is located).
Thank you in advance for your assistance.

Sub SaveAsA1()
ThisFile = Range("J1").Value & Range("C2").Value & Range("B4").Value & Range("A4").Value
ActiveWorkbook.SaveAs fileName:=ThisFile
Application.GetSaveAsFilename
End Sub

 

[K0st4din]

I think I found a way to separate my text and it went like this with these quotes:

ThisFile = Range("J1").Value & " " & Range("C2").Value & " " & Range("B4").Value & " " & Range("A4").Value

All I have left is how to save the new file in the same place where I opened the one I'm working on.
I don't know if I'm explaining it properly, so I'll write it a little longer.
I have a folder on my computer in which the file "Monthly report" is located, I open it and fill in the necessary information, then taking the information from the necessary cells, the file acquires a new name (in the example) Ivan Ivanov 1 2024 and save in the same folder where my file is, but with the new name. I make some attempts to do it myself and in one of the attempts something worked, but when I opened the file I saw that all the modules and macros in the new one were gone (lost) even though it was saved as .xls
I have absolutely no idea how to have everything old in the new file, like in the "mother file"