Creating Folders based on cell values

Hi All,

Wondered if some bright spark can assist with an issue im having?

I have a spreadsheet which has product column on the left and to the right are various document names as column headers.

I have colour codes: Green = Received, Orange = Requested, Red = attention. Users enter short text in the cells to describe the present position of the document, and colour code accordingly.

Scenario
(assume directory is already created as : "Product Name/Document header/<date & cell value here>) - bolded is already created in the directory.

User clicks on a cell, and clicks on "create folder" button. The button should pull the Product Name from the spreadsheet, pull the relevant document column header from where the user has selected the cell and create a new folder as above based on the date and active cell text: "<date & cell value/text here>". The date should be in this format yyyy/mm/dd so that the folders flow down the directory in date order, so that the folders are not in random order.

I want the "create folder" button to also check if the folder already exists as to not overwrite any previously created folder with the same date and cell value/text.


The aim is that the spreadsheet will be used as the hub.

Look forward to any replies and suggestions,

Best wishes.