I have a rather large workbook with around 10 sheets. i want to setup a
'export' button on this workbook that will allow a user to save
specific raw data (values from a given range and given worksheet) from
this workbook into another excel workbook and an 'import' button that
will allow user to import this raw data back to the location it was
exported from and use the existing formulas/links from this large
workbook.

I was thinking around these options:
1) Copy and then PasteValues from the large worksheet into another
workbook for exporting and same idea for importing
2) For all raw data, copy out all the values and put their
corresponding addresses in another excel sheet. e.g. column1:
Sheet1!$A$1, column2: value
and import it in by reading the address n value.

Suggestions on how I should go about this problem and a starting point
for getting started on the macros will be much appreciated.