Can a macro rename Excel files based on a cell's contents?

Can a macro rename Excel files based on a cell's contents? The problem maybe that I download these files en masse from a website and they all have 54-character long randomly generated filenames which I can rename by selecting all and then use the rename function to get a series of filenames like a, a(2), a(3), ... but I would rather have the files renamed based on the text that exists in cell B1 which is the title of the report. I also read somewhere that this kind of macro only works if the tabs have names like "Sheet 1"

Maybe:

Please Login or Register  to view this content.

I got my answer from a Redditor named johndoe555
at this link but now I thought of some more tweeks.

Can you add some more code to do the following?

• (1) Generate a prompt to enter 9 more characters to put both right before .xls and in cell A1
• (2) Copy the font formatting from cell B1 to cell A1
• (3) Put the date and time in cell W1 that is found in cell B2. The text in cell B2 always has the following format "Requested 393926326osel5105 (US) on 06/26/2014, 13:58"