Elle, if nobody has done it before, let me welcome you to the forums!
The issue you are dealing with might be quite simple (matching/converting data types), or extremely complex (data-densification). So we'll be best able to help you if you can post a packaged workbook with a bit of sample data. These links might be of interest:
We're happy to help, and we're glad you're here asking questions.