Copy and Paste macro needs to paste to a changing cell reference
 

1.User picks options from combo boxes to create a plan
2.User then runs a macro to copy finished plan.
3.Then selects the correct location within a database to paste.
4.Then runs another macro to paste data

I want to specify the paste location by using a cell reference generated by
the user entering a week number which then uses VLOOKUP to return the correct
cell within the database. My aim is to run one macro to copy and paste the
data to the correct location