Best practice for MACROs

Hi, I am using macros for my tests and models. But i am bit confused,
Should i use different files for each macro?
or small macros should be in single file and new files for big macros?
Or new file for each macro irrespective of lines of code?
If there is another way to look at it please mention.