I need help extracting a number from multiple excel files. This number is not on the same cell in each file however always the cell next to it is the same name i.e "subtotal". It is always on the same vertical column i.e "I". Please help! Since I have more than 900 files to extract one number from them and place it in another file.