I dont't know how to this with the markdown table syntax. But you can read sheets into R as a list of data frames with purrr::map and then use map(list-of-data-frames, knitr::kable to render multiple tables in an R Markdown document at once, they look the same as generatred by the table syntax