Does this work for you?
Pipeline to run all RMarkdown Files in sequence - R Markdown - Posit Community (rstudio.com)