i have 6 i would like to open - but not go to each file as it opens - but add
the file name to the current sheet as the files open.

when i close the files i would like to do the opposite and remove the file
name from the current sheet ast the files close. When i close the files 2 of
the files i need to save and the other 4 just close.

thanks
jack