Updating Macros to accomodate hidden columns and customize auto generated pages

Hello!

I was given what I think is a fairly complicated macros enabled workbook and asked to make changes to it. Plot twist: I have never used macros. I am well aware that I am out of my element and i do not have the time/resources to become an expert in it. I wanted to know if 1: the requests were possible. 2: if there are independent contractors/experts that would be able to do the work.

What i have is a workbook that includes about 4 tabs of instruction, 2 tabs of general information and 5 tabs of various order forms. This is for a furnishings supply company. So, the user would go in and fill in their info, then go through the room tabs and order different items (beds, plants, curtains, whatever). The original developer then created a set of macros enabled buttons that would then pull all the information from the various sheets and put them in another sheet as sort of a final order form.

What the company wants is a lot of specification on this final order form. For example, if the item ordered has a particular set of dimensions - they want that pulled out and placed on the order form. If there are lets say 5 items under "Window Treatments" they want all 5 items to prefill with certain information.

As a caveat, the original macros was done back in 2013/2014.

Any help would be greatly appreciated!!