Need Help Creating a Macro

Hello,

I am trying to create a macro and have been doing some research. Unfortunately every time I go running it gives me issues. I have done two days' worth of research and I am still having problems. Any help is greatly appreciated! 

I need a macro that:

Creates a folder in a specific location. That folder name needs to be base off of a cell in the excell document. 

Then save each sheet as a separate PDF inside the above-said folder with the name of the sheet and the above-named info that the folder was created.

If all goes well I would like a message to pop up and say done, if something doesn't work or the folder already exists to pop up an error message.