What is the formula to bring information from one tab into the summary tab but when dragging the formula to the next cell it automatically takes that same information from the following tab?
This is my expense summary tab
The data for this is tabs associated with the years. I need to copy the formula to the next cell and it should automatically bring in the info from the relevant year tab. sorry if this doesn't make sense hopefully someone out there understands it :)