I am trying to copy a range of data from one sheet to another. the range of data being copied is always a different length depending on the date selected, also the copied data has to be pasted to the bottom of the master copy list thereby creating a full list for the user to search for specific...