select * into sheet10
from (select * from sheet1
union all
select * from sheet2
union all
select * from sheet3
union all
select * from sheet4
union all
select * from sheet5
union all
select * from sheet6
union all
select * from sheet7
union all
select * from sheet8
union all
select * from sheet9)
