Hello,
First, I am no expert (otherwise I wouldn't be here right?), but I am attempting to create a pivot table using several worksheets in a book and after inputting:
SELECT * QA-Total
union all
SELECT * QA-IT
union all
SELECT * QA-Protocol
union all
SELECT * QA-Technical
into...