A mailmerge can only interrogate a single data source - in this case, a single worksheet. However, depending on your workbook layout, you may be able to combine that with a series of DATABASE fields that each query a different worksheet. For a demonstration, see:
https://www.msofficeforums.com/mail-...-multiple.html