I have a master sheet in a workbook. What I need is the information from the master sheet to auto transfer to the others based on date. Is there a formula for this? Many thanks

You can create a formula (or a macro) to do pretty much anything. But no, there is not "a" formula, there are 1000s. The actual formula (or macro) that does this for you would be completely dependent on your master sheet design, your sub sheet(s) design and the layout of the content on those sub sheets.

So, to actually offer suggestions, we would need to see an excellent sampling of your workbook. Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. Make sure the workbook demonstrates your desired results if possible, mock them up manually and point them out if they are not patently obvious.