I enclose a file which had three active sheets of data. On each sheet is the key column called "location"
I require a looping macro that will loop through the master file and place the data for each location into individual files where each file will be the location name.
So each finished location file will have three sheets with the same sheet names as the master file, but will only contain the data for its own location.
I will always place the master file in the directory C:\Documents before starting the macro and it will be fine for the finished location files to be placed here as well.

This is just a small example file of a larger file which contains about 2,000 rows across 40 locations.

If you can help me I would really appreciate it.