I would like to know using the Loop and reduce is it possible to hide and show the tabs, There will not be any data restriction or anything . Just i want to split the file in to 3 files .
No, reduce only reduces data, not sheets or sheet objects. If you want to split the file make two copies and delete the relevant sheets from the three documents.
