Help: Splitting large workbook into separate workbooks based on R column value.

Two things, first you need a macro to merge all 10 workbooks into a single sheet. Then you need a macro to parse out that one resulting sheet into 83 individual sheets.

'WORKBOOKS TO 1 SHEET STACKED
Here's a macro for collecting data from all files in a specific folder.

Workbooks to 1 Sheet

The parts of the code that need to be edited are colored to draw your attention.

=================

'SHEET1 TO MANY SHEETS
Here's a macro for parsing rows of data from one sheet to many sheets named for the same values in a specific column.

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing. There is a sample sheet there where you can test this out.