dynamic sheet name

I would like to create a dropdown that includes the names of all the sheets in the current workbook except the current one. In my case, I have 4 sheets labeled Sheet 1, Sheet 2, Sheet 3, and Calculations. I'd like to be able to select a sheet in the drop down, and have the value of the cell of...

Hi, I am trying to import a file that allows a user to select which tab and range to bring in from the import file. On my "Sheet Mapping" tab, C3 = tab I want to copy, D3 = Range I want to copy, B3=tab I want to copy to, and E3 = range I want to copy to. See picture attached. The data in the...

Hi. I'm trying to come up with a formula that will allow me to sum values across multiple sheets where the sheet name is referenced by a wildcard or some such thing. Situation: I have a spreadsheet that is comprised of a summary sheet and a number of sheets each containing the timesheet for a...

I have a spreadsheet with several worksheets and I want to do a data validation that is based on the content of that particular worksheet. When I create a named range using =offset(Sheet1!C3,-2,-1,4,0) for Sheet 1, I would like the sheet name to change based on the sheet I'm on. So when I'm in...

Guys Im new to VBA but Im currently working on a model that generates some statements for customers based on revenue and market share etc. The name of the customers change from month to month, I have a sheet where I dump the data and the model pulls all the data from this sheet. Since there...