multiple sheets to masterfile (different cells)- VBA

Dear all,

I'm new on this forum and I need your support.
I will really appreciate it if someone can help me


I have for 1 week like 50 PDF files that I have to convert to excel, so I found a program that creates 1 excel file with all the sheets.
now I need some data from each sheet ,to make it easy for you I marked the values that I need in 3 different colors. (see excel in attachment)

-adress : always in same cell (B8)
-order number: it depends if there is multiple work in 1 adress there are different order numbers
-Sap number : it will be in Cell F9/F10

conclusion : I need for each adress order number(s) and Sap number(s)

my question: is there any solution to create a masterfile with VBA ?
I Can't work with colors and sort/filter them later because as I mentioned there are like 50 sheets in 1 week.

Can someone help me? which function can i use ? or which way will be easiest?

thanks in advance.