VBA excel developer

General information for the business: office admin
Kind of development: Customization of existing program
Description of requirements/functionality: Changes to 2 existing VBA scripts VBA 1 and VBA 2

VBA1: existing functionality takes in 2 excel with some calculations and output another excel file. Unfortunately the current format for the 2 excel format has changed slightly with one or two additional columns.
Requirement to amend VBA1 to cater to the new format taking into account the shift in columns - very easy change for someone who knows VBA - 30 seconds job literally!

VBA2: existing functionality takes in 4 excel spreadsheet do some simple data manipulation to merge the files based on some rules and generate into an single output file. It is %95 working but Unfortunately it is outputing into the wrong coloumn under selective scenario.
Requirement to VBA2 1) is to fix the above problem and 2) new code to handle an additional input file to merge it into the same output file

Very straight forward for someone who knows VBA scripting, no complex calculations , just merge different files under a set of business rules which existing VBA scripts alraedy does but slight bug and one additional file to be added to it.
CMS and Admin requirements: new
Specific technologies required: VBA , excel
OS requirements: Windows
Extra notes: