I have a report that has individual data set up in form format, however, I want to pull the information from each of the worksheet into a data minable spreadsheet without having to reformatted each individual spreadsheet. Is this possible. I have attached an example.
As you can see it is not in single row format for basic VBA combining code, so I am confused. I have numerous reports (formatted in this manner) that contain almost three hundred individual reports. I need to format each into one data minable master sheet.
Any assistance would be greatly appreciated.![Eek! :eeek: :eeek:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)
As you can see it is not in single row format for basic VBA combining code, so I am confused. I have numerous reports (formatted in this manner) that contain almost three hundred individual reports. I need to format each into one data minable master sheet.
Any assistance would be greatly appreciated.
![Eek! :eeek: :eeek:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)