Running a code across multiple sheets

Hi,

I'm new to this forum and VBA. As I am a quite good general Excel user, I've been tasked with creating an automated forecasting spreadsheet at work. It is made up of a front sheet and multiple tabs depicting various statistical measures.

I've already got parts of the spreadsheet working, e.g:
1. On the 1st tab the user is asked to enter a date via an input box. This date is used to search for and open files in a location that contain the date entered by the user as a suffix (the original tables are created and output using SAS)
2. On the 2nd tab, data is fed into a standard form using vlookup
3. On the 3rd tab, data is fed in from a specified external location

My predicament is that although the pieces of code run in isolation on the individual sheets, the code isnt executed all the way through for all the sheets. Another thing is that although the date entered by the user can be used within the worksheet that contains the code, it has to be restated for other sheets in the workbook. Why is this? I've tried making the date field public but this doesn't work.

I'm sure the solution to this is very simple and I'm just being daft. Would appreciate any help with this at all.

Thanks

It probably is a simple fix. Try posting your code.

Thank you very much for the warm welcome and your prompt responses. I will try moving my code to module level to see if that helps when I return to work tomorrow. Will keep you all updated.

Thanks again.

It works at module level. That must have been where I was going wrong. Thank you for your help.