'How to add 3 columns on a importrange row with fields that are from lookups

ok, we know : {1,2} will create : a tableau of

A1 A2
1 2

what I need is :

{Importrange(Souces,"select *"),lookup Employee_name}

to build :

data1 data2 Employee Name
1 2 Name of employee

My current code works great to import Data1 and Data 2, but can't figure out how to include the 3rd column.

=Query(
{
March22!A10:V; 
April22!A10:V;
'May22'!A10:V;
June22!A10:V;
July22!A10:V;
August22!A10:V;
September22!A10:V;
October22!A10:V;
November22!A10:V;
December22!A10:V
}
,"Select * where Col3 is not null ")


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source