if you select B5:H125, do edit=>copy

then go to the other sheet and select the top left corner where you want the
data and do
Edit=>Paste Special and select values

does that give you the information you want?

You have probably already thought of this but you can use the Paste
Special > Paste Values and the "validated" information will appear.
This would be a manual process that none enjoys but I have no code
right now that would speed it up.

If this is a once in a life time event, after you have selected the
sheet where you are going to copy from, record a macro of you copying
the information and assign it a "shortcut key" (example: ctrl+L).

Next, select the cell where you want to paste and record another macro
of you pasting the information.  Again, assign it a "shortcut
key" (example: ctrl+N).

This way, while you gather your info, all you have to do is select
your sheet, you want to copy from, press ctrl+L > select an empty cell
on "Sheet1" and press ctrl+N

I do this when I am doing an adhoc task that requires speed over
finesse because how long it takes to perfect some VBA code.