Hide column in multiple files in subfolders from folder

Hi Forum,

I've been searching for a VBA solution for a long time and tried multiple threads on the web, but have not been able to make a final solution... So I need help!

I have a bigger Excel "eco system", which contains multiple worksheets in multiple workbooks.

Initial facts:

• The workbooks are placed in subfolders within a main folder
• The main folder is currently placed inside a Sharepoint environment
• The Workbooks could contain multiple sheets to be considered
  - If sheet contains date in cell D2, it should be considered
  - sheets with the name "Log" and "Instruction" should never be considered

What I want the VBA to do:

• An initial inputbox where to enter week number and year.
• Find the column where week number and year matches and hide the column.
• Proceed to next sheet if available or move further on to the next subfolder if available.
• Some sort of error handling / error messaging. "An error occured in file X, sheet X. Would you like to proceed or stop?"
• Possibility to use the VBA even though some of the sheets already have the matching column date hidden.
• Final MsgBox if the VBA succeeded.

Is there anyone out there, that have the time and VBA experience to help me with a proper solution?
Hope my explanation make sense... I would gladly add more info if needed. I've attched a simplfied version of the "eco system" for testing.

BR, Rasmus