So I have a tedious task of separating/filtering data and changing the format and making a new sheet.

My question is that if i record a macro for one sheet will it work for another keeping in mind that the number of rows and columns will ALWAYS change. 

There's no set number i would have to manually check that if i went into vba and changed the code accordingly.