Combine multiple Excel files into 1 Sheet

Hey guys,

Okay i think i have a super hard to do case. ( not sure )

I need to combine around 100 excel files ( all with 1 sheet ) into 1 excel file in 1 sheet.

Also the problem is that I need to :

1. Transfer the numbers on the picture as shown ( 1 ) into a separate collumn at the end of each sheet ( file )

2. Same as ( 1 ) but just another factor.

* keep in mind that ( 1 ) is unique for every excel file and ( 2 ) is not.

3. Delete this section of the file as shown on picture ( 3 )

4. Transfer this data to the new excel file with added ( 1 ) and ( 2 ) at the in form of new columns

Do you think this is possible with an excel macro?

Thanks a lot in advance!