please can someone help me out. I have Excel sheet from headquarters with 10 columns ( heading: car no, date of service, km, part no, fuel level, etc) with up to 3000 rows. I do receive this report with the same no of columns from different regions. I need to collate these reports into the main sheet. is there a way I can add the columns from the regional sheet to the main sheet. I know vlookup but it only adds one column at a time. Thank you.

Rizin:
please can someone help me out.
I have Excel sheet from headquarters with 10
columns ( heading: car no, date of service, km,
part no, fuel level, etc) with up to 3000 rows. I
do receive this report with the same no of
columns from different regions. I need to collate
these reports into the main sheet. is there a way
I can add the columns from the regional sheet to
the main sheet. I know vlookup but it only adds
one column at a time.
Thank you.

Hello please can you pm me