Mass creation of data via Worksheets and .PDF

[Craaaiguk]

Hi all


First time poster, long time reader

Wondering if you could help me with something please. I have been trying to piece bits of VBA code together from other topics on the forum

I have a Spreadsheet containing multiple lines of data. For this example lets says its Fruit.
From this data, I would like to create multiple worksheets via a Macro i.e. click the button and Excel will create a worksheet for each fruit name. There could be up to 1000 worksheets to produce.

I am then trying to create individual .PDF documents for each of these worksheets.

The files will be stored in a single place but reference back to the original Spreadsheet and call the .PDF document by the Cell Name. So if we use "C1" which would be "Fruit Name" as the example, I am hoping its possible for mass production of Worksheets and then .PDF documents that look like this:

C:/Craig/Excel Doc Pears 1.pdf
C:/Craig/Excel Doc Pears 2.pdf
C:/Craig/Excel Doc Apples 1.pdf
C:/Craig/Excel Doc Apples 2.pdf

Any help would be much appreciated. I have just saved over my master template and lost all of my work /cry!

Kind regards,

Craig