Merging queries created for planner all into one spreadsheet on one tab

Creating a report that fulls all data for every employee per day onto one spreadsheet in one tab. If you have an employee in one month off sick, in work, unpaid time off, on holiday you have to create 4/5 queries then merge together but they still show on seperate tabs making it difficult to check payroll for 100's of employees