It's possible,please check the below:
hope it helps you.
Incase my answer is helpful,please mark it as correct.
If you export pdf from two different workbooks, you need 3rd party of library to merge the pdf in command line. Or, you merge the two workbooks into a single one with different dashboard in it.