You need to use Append Range instead of Write Range. Write Range will overwrite the sheet so you will end up with just the data table extracted from the last page.
Alternative 2 is to create a second datatable variable and append the extracted datatable to it using the Merge Data Table activity. Then outside the while loop, you can use Write Range to save the merged data table to an Excel file.
