Using Excel 2007

What I would like to do is to take 10 cells 5 wide 2 deep and basically take
a "picture" of this and drop this in another area of the same spreadsheet. I
need to do this because of formating issues. I would like this be smart
enough when the source data changes the "picture" changes. I've seen this
done before, but not sure how to start (or what to search for). Not sure the
subject description is entirely accurate