I am a macro newbie so bear with me... what I'm trying to do in this macro is
be able to take all the information in a series of worksheets and compile it
into one master worksheet. I want to be able to edit and add things to the
individual sheets, and with the help of a macro, be able to automatically
update the master sheet (by pressing a button of some sort). I know how to
tell a macro to take a designated range from one sheet and paste it onto the
other, but I don't know how to code it to take all the rows and columns with
values in the cells. I.E. I don't want any blank cells in my master sheet and
I dont' want to have to constantly update ranges in the macro. Any and all
help is greatly appretiated, thanks!