I am very inexperienced at recording macros but I would like to setup a macro that if data in column A equals a particular word I would like to insert the whole row onto a corresponding sheet. For example column A is a list of departments, column B is a list of projects for that department and remaining columns are for tracking purposes of that project. The other sheets are broken into departments. I already have a list of 15 projects set-up to correspond to their correct sheets, but if additional columns are added, I would like it to automatically update and add that column to the correct sheet. I need separate sheets in order to quickly glance and possibly print for each department without having other departments projects listed on it.

Thank you for any and all help!