How to copy workbook and formulas to read to the present month
 

Hi
Hope some-one can assist. I have a workbook for stock control of various
items PER MONTH. It consists of a 3 worksheets (stock control, costings and
summary) and is named per month, example SEPTEMBER. Costings and summary
read from the stock control worksheet..
If I re-save the entire WORKBOOK for a new month, and call it October, the
costings and summary sheets still read values from Sep!
Is there any way i can save it each month and up-date the values to read
from the present month Stock Control worksheet. In particular can i do this
without a Macro as I am pretty useless with Macros.
Thanks in advance