how to convert pdf to excel and create folder by the pdf names and save the excel in those folders

[yashpisat]

directory: X:\Case study - 11\Code\Reports

Step 1: I am fetching the data from the pdf (filename:ceds) in excel by doing this: "Data -> get data -> from pdf".
Step 2: I then obtain 7 different sheets in a current excel file.
Step 3: I want to save this excel file in a folder(folder name:ceds) in the directory which is named after the pdf from which I got the data.
Step 4: I want to repeat the all steps for all the pdf present in that folder

Consider the following are the pdf file names in this directory: X:\Case study - 11\Code\Reports

ceds.pdf
ddfa.pdf
edfdf.pdf
fdf.pdf
gddg.pdf
qasd.pdf
rsda.pdf
mgh.pdf
sdd.pdf
asfaf