A small macro which can help consolidate 8-10 similar data files with about 15 columns. sample data sheet attached. i will have some 10 -15 such files on regular basis. we need to run a macro to create a single file. If needed cells may be protected. Please leave your number on mail. will call back.