This script was requested from a coleague of mine. It might be useful to anyone that has data files in which the header info is only found on the first database.
The script will copy the header info from one file to another file. This can be used when importing an excel file in which the data is over several tabs but the header info is only on the first tab. The script will take the header info from the first and copy it to the second file.
You can find the script here.