I have a spreadsheet with 3 worksheets. The 1st worksheet has a column which has a combination VLOOKUP functions - two different versions. One version pulls data from the 2nd worksheet while the other pulls data from the 3rd.

All these spreadsheets are comnfusing to the person who is to read the report. I want to get rid of the two extraneous worksheets and have just the 1st one. How can I retain the results of the function(s) and get rid of the other worksheets? I'd be will to create a new spreadsheet altogether as long is I don't have to link it to the original to retain the data.