Combine All Data From Multiple Worksheets In the Combine Worksheets step 1 dialog check Combine multiple worksheets from workbooks …
