Command Button Paste Values & Worksheet Export

I would like to execute a macros that will
1) Export the Monthly_Report worksheet and open a new Workbook for it
2) Copy and Paste Special Values the cells with formula arrays that reference the Data_Entry worksheet.

Gary,
1) I do not have any code other than what I could pull together with the Macro recorder (which is generally not useful)
ActiveSheet.Shapes("Button 1").Select
Selection.Find(What:="!", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, MatchCase:= _
False, SearchFormat:=False).Activate
Sheets("PWC EAC").Select

So I need this from scratch.

2) For the purposes of highlighting the cells with formula arrays that reference another sheet (Data_Entry), I have highlighted the cells in yellow on the Monthly_Report worksheet. The actual workbook that I will be putting this code into does NOT have yellow highlighted cells. I was thinking it might be possible to write the VBA script such that is is first searching and selecting all cells of the selected worksheet that reference cells from another worksheet (the Find criteria would look for Data_Entry! in the Formula of each cell). I just want to copy those specific cells and paste special->values on the Exported copy of the Monthly_Report worksheet so that it doesn't maintain links to the parent workbook.

The attached is a general mock-up workbook so I am not posting business sensitive information.