Rahyan,
The code does not do much, excep to select and copy in to active sheet. You are copying from format sheeet to active sheet.
I do not know what you are trying to do. Part of the lines on function seems to be copied from Ron's code. Where are these 25 spredsheets? Are you trying to consolidate these sheets in to one on the same with workook?