i have approx 100 workbooks in a folder which contain data on individual staff

i would like to be able to have a "index" page which reads all the
information from all the other workbooks in rows

in the data workbooks the info is always in the same place,

is this possible in vba