How would I separate tabs into different workbook (no need to save at this point) by the first four characters of the Tab name using VBA?
example; Canada, Chile, Colombia, would be separated by cana, chil, colo. There is additional information on each tab but these would be leading.