Copy Paste Values Only From One Sheet Into Next Blank Row

The problem I can't seem to solve is copying a list of names from Column AF from multiple sheets ("Tuesday"),("Wednesday"),("Thursday")("Friday")
and pasting only the values over to a sheet ("Master"). The names are generated from a formula, so pasting only the values is critical.

Each day I want the list to be regenerated copying all the names from each worksheet onto the Master without copying the information over and

The range may vary (i.e.) Tuesday may have 3 names, Wednesday may have 6 names, etc. and more names may be periodically added to the list

Tuesday Wednesday Thursday Friday Master (Sheet Name)
AF AF AF AF A (Column)

Billy Hank Nelly Aaron Billy
Sally Jose Ranise Sally
Joey Fred Joey
Raul Hank
Jose
Fred
Raul
Nelly
Ranise
Aaron

Any help would be much appreciated,

Tom